Thread: Find the last cell in a selected range?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
  
Posts: 2,452
Default Find the last cell in a selected range?
dim rng as range

set rng = selection.cells(selection.cells.count)

RBS


"J@Y" wrote in message
...
I have a user selecting a range, how would I put the ending cell in the
range
in a variable?

Reply With QuoteReply With Quote