Enter Values Offset From Current Selection

  • Good afternoon,

    I am sure that this is something simple but I have tried searching the forum but did not find quite what I am looking for.

    Is there a way that values can be entered into cells offset from the currently selected range? I know I can have the following work when there is only one cell selected:

    ActiveCell.Offset(1, 0).Value = 1

    However, I would like to be able to put 1 in the cells one row down for each cell selected, for example if the current selection is $D$6:$F$6,$I$6, then $D$7:$F$7,$I$7 will contain the number 1 once the code has run.

    Please let me know if I can clarify anything for you.

    Thanks in advance,

    [FONT="Comic Sans MS"]Averil Pretty[/FONT]

  • Re: Enter Values Offset From Current Selection

    Thanks jindon and Mavyak,

    I have used your suggestion jindon, and it works perfectly.

    Thank you so much,

    [FONT="Comic Sans MS"]Averil Pretty[/FONT]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!