Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to modify the code in a macro to let me select a range of cells
relative to an active cell. I know how to select a SINGLE cell relative to an active cell using OFFSET. For example, selecting a cell two columns to the right and on the same row as an active cell is accomplished with: ActiveCell.Offset(0,2).Select But I can't figure out how to use relative cells with RANGE. What if I wanted to select the cells that are two AND three columns to the right of an active cell? Thanks for any tips. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting simple range relative to the active cell. | Excel Programming | |||
Selecting Range in non-active sheet | Excel Programming | |||
Range selecting in non-active workbook | Excel Programming | |||
Selecting an active cell | Excel Programming | |||
selecting a cell relative to activecell in an excel macro | Excel Programming |