Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code to select two cells:
Set rng2 = Range(cell.Offset(0, 0).Address & ":" & _ cell.Offset(0, -1).Address) If rng1 Is Nothing Then Set rng1 = rng2 Else Set rng1 = Union(rng1, rng2) End If End If Next cell This code selects a cell and the cell to its left. I also need to select the cells one row up and one column to the right of this cell (3 cells). I think that this code would work for the second part of the selection I need: Set rng2 = Range(cell.Offset(1, 1).Address & ":" & _ cell.Offset(1, 4).Address) Is there a way to combine this line with my first code example to be able to select all of these cells at the same time? Any advice would be appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cell selection code | Excel Discussion (Misc queries) | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
Need Code For Selection | Excel Programming | |||
Selection code | Excel Programming | |||
code for showing userform on cell selection | Excel Programming |