selecting adjacent cells
 

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

selecting adjacent cells
 

Mark,

Try something like


"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

selecting adjacent cells
 

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

selecting adjacent cells
 

Mark

ActiveCell.Resize(3).Select to grab 3 cells in one column.

ActiveCell.Resize(3, 3).Select to grab 9 cells in 3 columns.


Gord Dibben Excel MVP

On Thu, 1 Dec 2005 16:59:49 +0000, wfcmark
wrote:


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

Thanks Guys - exactly what I wanted...

Cheers,

Mark