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:


    Code
    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,
    Averil

    -------------
    [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,
    Averil

    -------------
    [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!