I have a macro for my spread sheet. When I get to Range, I want to say

Range (J ) .Select

What can I put after the J to have the range always be on whatever active
row that I am currently on, without actually putting the row number down.

Range (JActiveCell) .Select obviously doesn't work. Any ideas. Thank you