VBA Select mutiple rows (ending range variable)

Originally Posted by JieJenn

Rows("23:" & Cells(Rows.Count, 4).End(xlUp).Row).Select

Your answer to your 2nd question
Rows(ActiveCell.Row & ":" & Cells(Rows.Count, 5).End(xlUp).Row).Select

THANK YOU! Certainly solves the first question, perfectly.
But doesn't solve my second question - but I don't really NEED to know that right now. My issues pertaining to my work is answered (thanks to you). The second question was for my own knowledge. Marking the thread as SOLVED.