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

I wnnt to learn about QTP Automation Framework,please give URL Address to get more information about AFW.

0 Answers   UHG,


What are the different types of checkpoints?

0 Answers  


what is difference between normal mode and fast mode?

1 Answers  


There are 10 rows in the datatable. How can we fetch 2 rows and then skip 3rd row. After that, pick 4th & 5th row and skip 6th row. Please share code

0 Answers  


what are the utilities and drivers

0 Answers   Cap Gemini,


how to test Web application using QTP software

0 Answers  


what are build and version plz explain why nomber changes in build and version?

3 Answers  


wht is the difference between action and functio?

3 Answers  


How to Practice QTP Scripts?

1 Answers  


What is the file extension of the code file in qtp?

0 Answers  


When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.

0 Answers  


waht is the difference between QTP 8.2 and 9.0 version

15 Answers   AppLabs, CTS, Polaris,


Categories