View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Selecting Contiguous Ranges on a Sheet

How do you select the contiguous rangs in a spreadsheet? I seem to remeber
that you can select the entire sheet by going:

Cells().Select

I know Cells() has an Area property but
Cells().Areas.Select

does not work.

Thanks

EM