In automating of my script. the Rowcount, Getcelldata and Activatecell are not working as expected.

Mainly, the prob is with rowcount. Whenever the script encounters with this line having rowcount, it error out saying “Exception occurred”

Then I have to stop the script. And if I run the script from that step using “Run from step” command, it execute it. And again that error comes at the next step containing the Rowcount.

Is there another way to know how to determine the number of rows except using the rowcount method. It will be great if you provide any VB script that works as a substitute for rowcount and Getcelldata.