selecting cell : combination of column of active cell & last row

[littlepete]

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 !!!

 

[Joe4]

Use Cells instead of Range, where you can use the Column number (I think I may have helped you with something like this before):

Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select

 

[BSALV]

reminder : if you have a filter working at that time and you use for example end(xlup), you get the last not-empty visible cell. for example at row 100, even if row101-200 are not empty but hidden because of the active filter. So if you use this method, the filter has to be disabled.

 

[littlepete]

Use Cells instead of Range, where you can use the Column number (I think I may have helped you with something like this before):

Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select

thank you i adjusted all goto functions to stay within my list home - end - ctrl home & end
and show the first row(same col.) (with 6 as row number, and without the end.xldown/up) and show the last row (same col.)

so glad that worked !!!
have a nice evening !!!

 

[Joe4]

You are welcome!
Glad I was able to help.