Home |
Search |
Today's Posts |
#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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
|
|||
|
|||
Thanks Guys - exactly what I wanted...
Cheers, Mark Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum column if multiple criteria are met in adjacent cells | Excel Worksheet Functions | |||
Displaying contents of adjacent cells. | Excel Discussion (Misc queries) | |||
selecting non adjacent cells | Excel Worksheet Functions | |||
selecting cells | Excel Discussion (Misc queries) | |||
Hightlighting crosshairs when selecting cells | Excel Discussion (Misc queries) |