excel macros

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

is there a way to determine the range of populated cells
in a spreadsheet?
 
steve,

Populated cells???

Try
ActiveSheet.UsedRange.Select

Possibly you just want a contiguous range??
Activecell.currentregion.select

You can look up both of these in the VBA Help.

John
 
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

varying table length in a MACRO 2
Excel 2007 1
Macro 1
Macro to insert pictures in comments 8
Excel macros graphs work on one laptop, but do not on another. Wh 1
Windows 8 Overwriting Duplicates 0
Macro Help: Concatenate Populated Cells in Column A 3
Remove or delete lists/filters. 1

Back
Top