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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a range in code
JCanyoneer wrote:
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? Range("O" & SCell + 5 & ":Q" & SCell + 12).Select Alan Beban |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a range in code
Range("O" & SCell + 5 & ":Q" & SCell + 12).Select
-- HTH RP (remove nothere from the email address if mailing direct) "JCanyoneer" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a range in code
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany "JCanyoneer" schrieb im Newsbeitrag ... 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? |
Reply |
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 |