Thread: selecting a range according to the longest column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Smith John Smith is offline
external usenet poster
  
Posts: 62
Default selecting a range according to the longest column
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