number of rows in spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I determine the number of rows in a spreadsheet useing visual basic. This number is dynamic and will be used to determine the end of a loop

seeker52
 
In general an approach is:
assume column A can be used for this purpose

set rng = cells(rows.count,1).End(xlup)

msgbox "Last row is " & rng.row



--
Regards,
Tom Ogilvy


seeker52 said:
How can I determine the number of rows in a spreadsheet useing visual
Click to expand...
basic. This number is dynamic and will be used to determine the end of a
loop.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying data from several spreadsheets into a new spreadsheet 2
Count occurances in a range. 5
Comparing values in a cell and looping 1
how to design spreadsheets to collect data and display the totalmaterial used in a plating departmen 13
Sum of sub groups 3
Tricky question about rows of cells. 4
Get Data set range from closed workbook 2
Programming "Shape" objects 14

Back
Top