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:
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,