View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default spreadsheet range selection

I have a spreadsheet with stuff in various cells but my main area of interest
is A11 to I(where ever it ends)

For some reason when I select using this
Range("A11").CurrentRegion.Select

I get header cells and other unwanted stuff, it actually selects A8 to I
(where ever it ends)

How do I select only A11 to I(where ever it ends) regardless of what is
around it?

Thanks
Mike