Excel.Range

K

KARL DEWEY

Post your question to an Excel newsgroup.
I know a little about Excel but the way you stated your question baffles me.
Maybe you need to also state it in a different manner.
 
S

SIN

i am sorry i mean : total rows.
The code is in vb:

Set xlApp = CreateObject("Excel.Application")
xlApp.DisplayAlerts = False
Set xlWkb = xlApp.Workbooks.Open("c:\test.xls")
Set xlSht = xlWkb.Sheets(1)
Set xlRng = xlSht.Cells(1, 1)

thanks
 
S

SIN

the answer is:
Dim v_totalrows As Integer
v_totalrows = ActiveSheet.UsedRange.Rows.count
 
Top