Thread: Expanding Selection Range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Expanding Selection Range
selection.Resize(,selection.columns.count+1).Selec t

--
Regards,
Tom Ogilvy

"Jim May" wrote in message
...
In my code the current range that is selection via
Selection. is A5:C3000; what next line of code
would change the Selection to A5:D3000? (one additional
column to be included)
TIA,
Jim May


Reply With QuoteReply With Quote