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 How to make last cell in current selection the activecell

Selection.Cells(Selection.Cells.Count).Activate

RBS

"Snowsride" wrote in message
...
I asked a similar but wrongly worded question earlier so apologies for what
seems repetition.

I need some code to make the last cell in the current selection (not the
CurrentRegion) the active cell.

Grateful for any help.