ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to make last cell in current selection the activecell (https://www.excelbanter.com/excel-programming/372171-how-make-last-cell-current-selection-activecell.html)

Snowsride

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

RB Smissaert

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.




All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com