i have 4 spreadsheets opened, each workbook hast at least 3+ worksheets
so i just want to get the number of rows in the active sheet of an active workbook
i have 4 spreadsheets opened, each workbook hast at least 3+ worksheets
so i just want to get the number of rows in the active sheet of an active workbook
If all of your files are >2003 file format then by default every sheet of the workbooks will be having 1048576 rows
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I am assuming that you want to know no. of rows used in each sheet.
You can assign this a variable for further processing.Please Login or Register to view this content.
Last edited by Kiran.Sunkara; 12-26-2012 at 01:28 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks