Macro Range

M

mbnspect

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
 
R

Rick Rothstein \(MVP - VB\)

And another possibility...

Cells(ActiveCell.Row, "J").Select

or

Cells(ActiveCell.Row, 10).Select

Rick


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

hth
Carlo
 
Top