Macro Range
 

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

Macro Range
 

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

Macro Range
 

And another possibility...

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

or

Cells(ActiveCell.Row, 10).Select

Rick


"carlo" wrote in message
...
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