move active cell one to the right - excel 2000

[OutlawoftheMarsh]

Hi. I'm not real good with code/macros. I would love to purchase some kind of material to ameliorate this condition rather than pestering generous comrades such as yourselves, but I don't have a real reliable mailing address here in the Middle Kingdom, and rest assured that there is a dearth of English language materials on the subject.

What is the command to move the active cell? For example, suppose C15 is the active cell, and I want a macro to move the active cell one to the right. Or maybe 3 to the right, and one down. The deal is, I'd like to be able to make the active cell move in a fixed pattern relative to the cell that is already active (before the macro is run), rather than moving to a final fixed destination (which would be something that even I could figure out). In other words, if I select R20, and run the macro (or whatever other mechanism you guys come up with), then R21 will be selected; likewise, I can click G12, run the macro, and G13 will be selected.

Thanks,

Outlaw

 

[chomsky]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveCell.Offset(0, 9).Select
End Sub

I WANT IT TO SELECT 9 CELLS TO THE RIGHT BUT IT MOVES A LOT MORE THAN THAT WHEN A SELECT A CELL IN COLUMN A.

 

[rackers7690]

Hate to be an 'over critical' observer, but surely this is more correct?

r = # of rows you want to move (-r if you want to move up)
c = # of columns to move (-c if you want to move left)

Sorry to be a pain but didn't read correctly.

 

[AT BABU]

Hi. I'm not real good with code/macros. I would love to purchase some kind of material to ameliorate this condition rather than pestering generous comrades such as yourselves, but I don't have a real reliable mailing address here in the Middle Kingdom, and rest assured that there is a dearth of English language materials on the subject.

What is the command to move the active cell? For example, suppose C15 is the active cell, and I want a macro to move the active cell one to the right. Or maybe 3 to the right, and one down. The deal is, I'd like to be able to make the active cell move in a fixed pattern relative to the cell that is already active (before the macro is run), rather than moving to a final fixed destination (which would be something that even I could figure out). In other words, if I select R20, and run the macro (or whatever other mechanism you guys come up with), then R21 will be selected; likewise, I can click G12, run the macro, and G13 will be selected.

Thanks,

Outlaw

https://www.excelhowto.com/macros/select-a-range-in-excel-vba/