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