W
wfcmark
Hi,
new(ish) to excel and to this site (but have searched previous posts
for help
regularly).
Anyway, how do I select a cell, and then when hitting a button,
automatically select the next 2 cells in the row for pasting.
I am okay with the button, recording macros etc, but when I try to do
that,
it just shows select range in the VBA. What I need (I think!) is to
know how to extend selection by 2 cells.
The reason is so a selection is only one click and not several...
Hope this is clear!
Many thanks, Mark
new(ish) to excel and to this site (but have searched previous posts
for help
regularly).
Anyway, how do I select a cell, and then when hitting a button,
automatically select the next 2 cells in the row for pasting.
I am okay with the button, recording macros etc, but when I try to do
that,
it just shows select range in the VBA. What I need (I think!) is to
know how to extend selection by 2 cells.
The reason is so a selection is only one click and not several...
Hope this is clear!
Many thanks, Mark