Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am trying to select a range of cells after selecting a cell based on an activecell.offset. For example, a line in my code looks like this: ActiveCell.Offset(2, -3).Select Now I want to select a range of three cells (the selected cell and one cell before and after the selected cell). The absolute location will not always be the same, therefore can not select range based on absolute cell references (i.e. A1:A3 or .cells(1,3),.cells(3,3) for example). Can't figure out how to do it. Any help?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation - List - Setting Range from a macro | Excel Discussion (Misc queries) | |||
ActiveCell in a Range? | Excel Discussion (Misc queries) | |||
Trigger macro if an Activecell is within a specific Range | Excel Programming | |||
Trigger macro if an Activecell is within a specific Range | Excel Programming | |||
Macro in VBA: Setting a variable print range HELP NEEDED!! | Excel Programming |