Looping wont stop

[laura]

Hi,
I have 3 values in a datasheet, with my code the datasheet keeps going on after the 3rd iteration which makes it fail.
Can anyone please help as the code actually works for other sections of the script.
My code is -

Code:

rc =datatable.getrowcount
for i =1 to rc
datatable.setcurrentrow i

------

Next

Can anyone tell me what is going on please.and i have set the File settings to 'run one iteration'

Thanks

[basanth27]

What does msgbox rc display ?

[laura]

It was howing 5. i have now creted a new datasheet all is fine now. thanks for the idea of checking using msg box

[basanth27]

So your 2 rows were merely created from the 'virtual row" flag being set by QTP reading a imported excel. During these situations you must select the last 2 rows after the end of data and simply right click and then click on Delete. sometimes this helps, else just create a new sheet as you did.

In either case, You are most welcome :-)