Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using code on a userform and part of the code finds the last cell used
in row V then selects the cell 9 cells to the left, on this occasion row M, as follows Range("v7").Select Range("V7").End(xlDown).Select ActiveCell.Offset(0, -9).Select How I can select the 5 cells to the right and 3 cells down at the same time. i.e., my code would select cell M3, i then want to highlight M3 to R5. From there i need to add borders around these cells but I think I can manage that bit. Thanks Ian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select multiple adjacent cells of multiple cells without selecting | New Users to Excel | |||
Select multiple adjacent cells of multiple cells without selecting | Excel Worksheet Functions | |||
Selecting Multiple Cells | Excel Discussion (Misc queries) | |||
How do I keep from selecting multiple cells | Excel Worksheet Functions | |||
How to change shade of cells when selecting multiple cells | Excel Discussion (Misc queries) |