littlepete
Well-known Member
- Joined
- Mar 26, 2015
- Messages
- 503
- Office Version
- 365
- Platform
- Windows
hello all
I'm trying to combine to things together :
i'm trying to go to the last row in the same column as the active cell ;
i'm also trying to achieve the opposite :
trying to go to the first row (under the titles) in the same column as the active cell ...
is not working : Range(ActiveCell.Column & Cells.Rows.Count).End(xlUp).Select
partially working (fixed column) : Range("B" & Cells.Rows.Count).End(xlUp).Select
there could be empty cells in the column, they need to be skipped...
not sure yet how to make the perfect combination thank you !!!
I'm trying to combine to things together :
i'm trying to go to the last row in the same column as the active cell ;
i'm also trying to achieve the opposite :
trying to go to the first row (under the titles) in the same column as the active cell ...
is not working : Range(ActiveCell.Column & Cells.Rows.Count).End(xlUp).Select
partially working (fixed column) : Range("B" & Cells.Rows.Count).End(xlUp).Select
there could be empty cells in the column, they need to be skipped...
not sure yet how to make the perfect combination thank you !!!