Thread: selecting a range according to the longest column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis Dana DeLouis is offline
external usenet poster
  
Posts: 947
Default selecting a range according to the longest column
If there is no surrounding data, then one of a few ways...

[A1].CurrentRegion.Select

HTH
Dana DeLouis


John Smith wrote:
Say, I have data in A1-A3, B1-B7, C1-C5. How do I programmatically
select A1-C7 with one command?

"range([A1],C[1].end(xldown)).select" doesn't do it.
Reply With QuoteReply With Quote