Mark,
Try something like
ActiveCell.Resize(, 3).Select
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"wfcmark" wrote in message
...
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
--
wfcmark