Macros

[Elly]

Hi!

Would it be possible to use a macro to move the cursor
from a (variable) cell on the current row to a (fixed)
cell on that same row - for example, from A2 to R2, B4 to
R4, C5 to R5, etc?

TIA!

Elly
x

 

[Dave Peterson]

Something like:

activesheet.cells(activecell.row,"R").select

might do it for you.

 

[Don Guillett]

another. Change 12 to fit your desires.
activecell.offset(,12).select

 

[Dave Peterson]

To always end in the same column (like column R)???

maybe:

ActiveCell.Offset(, 18 - ActiveCell.Column).Select

 

[Don Guillett]

Good thought.