If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 -- wfcmark |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
selecting adjacent cells
Thanks Guys - exactly what I wanted... Cheers, Mark Gord Dibben Wrote: 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 -- wfcmark |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
formula for selecting all cells | Andre | General Discussion | 1 | November 25th, 2005 05:34 PM |
Selecting cells using shortcut keys not mouse | Griff | General Discussion | 2 | April 14th, 2005 09:15 AM |
Selecting Multiple Cells. | joenjoe | General Discussion | 2 | August 27th, 2004 03:40 AM |
"Formula omits adjacent cells" Error. | John Prendergast | Worksheet Functions | 3 | February 7th, 2004 06:57 PM |
Selecting Cells | Scott | Worksheet Functions | 2 | October 10th, 2003 02:38 PM |