Macro Range

  • Thread starter Thread starter mbnspect
  • Start date Start date
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
 
And another possibility...

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

or

Cells(ActiveCell.Row, 10).Select

Rick


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

hth
Carlo
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

writing a sort macro 2
Macro range 2
After Macro runs, no cell activated - what am I missing? 2
Macro copy from range 3
Change Filename in Macro 3
Macro to hide rows with zero in specifc column range 2
macro add 10
Macro to sort variable data range fails 1

Back
Top