You can use the below vbscript to find out the no of rows

Dim objXL
Set objXL = WScript.CreateObject("Excel.Application")
objXL.Visible = TRUE
OBJXL.ActiveSheet.UsedRange.Select
rc = OBJXL.Selection.Rows.Count

Where 'rc' is the no of rows...

Regards
Eugene



                                                                           
             "Talapatra, Aruna                                             
             \(GE                                                          
             Healthcare\)"                                              To 
             <Aruna.Talapatra@         <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>   
             ge.com>                                                    cc 
                                                                           
             07.03.2006 03:18                                      Subject 
             AM                         Return number of rows         
                                                                           
                                                                           
             Please respond to                                             
             xsl-list@xxxxxxxx                                             
              lberrytech.com                                               
                                                                           
                                                                           





Hello:

I am processing an excel sheet which contains 5 columns..

There may be any number of rows in this excel.

I am trying to figure out how I can get the number of rows that are
populated in this excel sheet.

Can someone please help me out.

Eg.

Index LastName FirstName DOB

1 Test1 Name1 XXX

2 Test2 Name2 XXX

3 Test3 Name3 XXX

4 Test4 Name4 XXX

Number of rows should return 4.

Thanks in advance!

Aruna