Making an active cell jump to the right

[vladimir70]

Hello everybody!
How could I make an active cell jump one, two, three etc. places in one instance to the right?
Regards, Vladimir

[tigeravatar]

Vladimir,

Welcome to the forum. I assume you are talking about using VBA. To select/activate a cell to the right of the current activecell, you would use the range.Offset property. ActiveCell counts as a range, so you can just put:

Please Login or Register  to view this content.

In the .Offset, the first number is the number of rows (positive numbers move the rows down, negative numbers move the row up) and the second number is the number of columns (positive moves right, negative moves left). So Offset(0,1) is for the cell 1 to the right

Hope that helps,
~tigeravatar