| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the number of used rows from excel spreadsheet in VBScr
I need a piece of script, that connects to an ALREADY OPEN excel spreadsheet
and get the number of used rows, using VBScript. So far I was unable to do it and I found solutions only in VB or other languages. Please help if you know how to. Thanks, Judit |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get the number of used rows from excel spreadsheet in VBScr
Hi JP
You can use MsgBox ActiveSheet.UsedRange.Rows.Count Remember this is not always give you the last row with data. The usedrange not always start in row 1 -- Regards Ron de Bruin http://www.rondebruin.nl "JP" wrote in message ... I need a piece of script, that connects to an ALREADY OPEN excel spreadsheet and get the number of used rows, using VBScript. So far I was unable to do it and I found solutions only in VB or other languages. Please help if you know how to. Thanks, Judit |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get the number of used rows from excel spreadsheet in V
Thanks for the help, but my problem really is not to get the used rows but
first to get an object reference to an already open excel spreadsheet. If I run this line it will give me and error "Object required 'ActiveSheet'", so I need to find out how to get an object reference to an already open excel sheet. It would be gread if you could help me with that. Thanks a bunch. Judit "Ron de Bruin" wrote: Hi JP You can use MsgBox ActiveSheet.UsedRange.Rows.Count Remember this is not always give you the last row with data. The usedrange not always start in row 1 -- Regards Ron de Bruin http://www.rondebruin.nl "JP" wrote in message ... I need a piece of script, that connects to an ALREADY OPEN excel spreadsheet and get the number of used rows, using VBScript. So far I was unable to do it and I found solutions only in VB or other languages. Please help if you know how to. Thanks, Judit |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum the number of rows in a spreadsheet given 2 criteria??? | Excel Discussion (Misc queries) | |||
| How to number lines (rows) on both sides of spreadsheet | Excel Worksheet Functions | |||
| What is the maximum number of rows in an Excel spreadsheet ? | Excel Discussion (Misc queries) | |||
| How do I limit number of rows and columns on a spreadsheet | New Users to Excel | |||
| number of rows in spreadsheet | Excel Programming | |||
Linear Mode
