Range("J" & activecell.row).select

hth
Carlo

On Jan 17, 2:21*pm, mbnspect
wrote:
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