Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a range in code
I an writing a subroutine that passes a cell value and uses it to select
certain cells for manipulation. I would like to Select a range of cells to set the properties on but cant get the syntax correct. The code looks like this: Sub SingleDoor(SCell as Integer) Range("O" & SCell+5 ":Q" Scell+12).select My problem is with the quotes. Any see the problem? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CODE 2 SELECT SHEETS LISTED IN A RANGE | Excel Discussion (Misc queries) | |||
Code to select range | Excel Discussion (Misc queries) | |||
select range from code | Excel Programming | |||
How do I select this range using code....another try at it. | Excel Programming | |||
How do I select this range using code? | Excel Programming |