P.S. I know this one below is probably the easiest this in the world, but
how do I select the "current row" or "current column" (separately) without
specifying a column range. I just want "current" or "active" one.

Sorry, I didn't see this question on my first reading of your post. To
select the row or column for the row or column the active cell is in, try
these...

ActiveCell.EntireRow.Select

ActiveCell.EntireColumn.Select

--
Rick (MVP - Excel)