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

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

Question Posted / venugopal592

2 Answers
7213 Views
HP, I also Faced
E-Mail Answers

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

how do you find the number of occurences of string QTP from the expression , " QTP+QTP=2QTP"

5 Answers IBM,

How can we retrieve the links from a web page where links are dynamically changing(for eg take a online shopping website) and then we have to click on all the links present in the webpage and go to the repective pages and again come back to the first page..

2 Answers

diff between qtp versions from 8.5

0 Answers Semantic Space,

How to compare source and target database in testing? Can anybody please tell me in detail the procedure how to compare it?

1 Answers

What is the use of Regular expression?

5 Answers

what is the diff between Procedure and function

3 Answers iFlex,

How to call a test from another test?

0 Answers

How to change the screen name while running the test.