Excel.Range

[Guest]

hi,
how can i know the total column in excel Sheets.

thanks

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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