how to get no.of non empty rows in a excel sheet through
vb-script

Answers were Sorted based on User's Feedback



how to get no.of non empty rows in a excel sheet through vb-script..

Answer / xxxx

rcount=usedrange.rows.count

Is This Answer Correct ?    6 Yes 0 No

how to get no.of non empty rows in a excel sheet through vb-script..

Answer / hari

by writing the for loop and you have to initialize for (i=0;
i<==num(i), i++)
Next

This loop will include that the rowcount it will take first
0 and total count it wil compare to the max of rows if it
wil true it will counts the nect row count

Is This Answer Correct ?    2 Yes 7 No

Post New Answer

More QTP Interview Questions

hi gavasker i want how to merg OR's in QTP 8.2 by QTP Plus

1 Answers  


Presently i am working on QTP 8.2 Version,i want to know features in 9.2 version, because i have not sufficient time to put the effort on the 9.2 version

0 Answers  


What exactly is the difference among all the three recording modes.

5 Answers   Accenture,


hello, i was install Q.T.P.8.2 in windows xp version .when i am running my programs all the desktop icons are disappear why so. please guide me anybody how can i come out side this problem.

3 Answers  


what is L-trim function will do?

2 Answers  






Test script is generated and it is enhanced.It is required to be saved.But the disk space is insufficient.You are not permitted to delete any scripts.How are you going to save?

1 Answers   Accenture, DELL,


what is Compile Module in QTP? what exactly it contains Functions or Actions?

2 Answers   GE,


Can we call a parameter from an action to other action?

4 Answers  


HOW CAN WE GET THE VALUE OF TEXT BOX IN QTP? can you give me sample script for this where there is some condition. like if "text" THEN msgbox() else endif

7 Answers   Xavient,


iam working in QTP for 2+ of exp if i attend the interview what r questions asked in perfomence testing{loadrunner} ? pls any one can say answer to this question?

0 Answers   Infosys,


How can we use XML in QTP?

1 Answers  


where we are going to write the descriptive programming.for example we are invoking qtp application where we are going to write that code

3 Answers  


Categories