| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range().select function in a macro
In a macro, how do you select a range of cells relative to the current
position. i.e. range(RC,[R+1C+8]).select <=tried this but does not work Selecting from current row and column position, to the next rox, and next 8 columns. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
range().select function in a macro
ActiveCell.Resize(2,8).Select
-- Charles Chickering "A good example is twice the value of good advice." "Peter" wrote: In a macro, how do you select a range of cells relative to the current position. i.e. range(RC,[R+1C+8]).select <=tried this but does not work Selecting from current row and column position, to the next rox, and next 8 columns. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select range in macro | Excel Discussion (Misc queries) | |||
| How do I use a macro to select a range? | Excel Programming | |||
| select a range in a macro | Excel Discussion (Misc queries) | |||
| Select.Range function in VB IF statements? | Excel Programming | |||
| When you select a range with a macro | Excel Programming | |||
Linear Mode
