| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range in code
Here is a line of code I'm having problems with:
Sub SingleDoor(SCell as Integer) Range("A" & SCell + 5 ":C" & SCell + 10) I know it is my syntax that is wrong. Can anyone help? I would like to select the range of cell from A5:C10 if SCell is passed as 1. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting a range in code
Hi
Range("A" & SCell + 4 &":C" & SCell + 9).select -- Regards Frank Kabel Frankfurt, Germany "JCanyoneer" schrieb im Newsbeitrag ... Here is a line of code I'm having problems with: Sub SingleDoor(SCell as Integer) Range("A" & SCell + 5 ":C" & SCell + 10) I know it is my syntax that is wrong. Can anyone help? I would like to select the range of cell from A5:C10 if SCell is passed as 1. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting a range in code
Hey, you even spotted his mistaken math :-)
Bob "Frank Kabel" wrote in message ... Hi Range("A" & SCell + 4 &":C" & SCell + 9).select -- Regards Frank Kabel Frankfurt, Germany "JCanyoneer" schrieb im Newsbeitrag ... Here is a line of code I'm having problems with: Sub SingleDoor(SCell as Integer) Range("A" & SCell + 5 ":C" & SCell + 10) I know it is my syntax that is wrong. Can anyone help? I would like to select the range of cell from A5:C10 if SCell is passed as 1. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting a range in code
:-)
last efforts before quiting working for today :-) He was really tricky also a missing apersand...) -- Regards Frank Kabel Frankfurt, Germany "Bob Phillips" schrieb im Newsbeitrag ... Hey, you even spotted his mistaken math :-) Bob "Frank Kabel" wrote in message ... Hi Range("A" & SCell + 4 &":C" & SCell + 9).select -- Regards Frank Kabel Frankfurt, Germany "JCanyoneer" schrieb im Newsbeitrag ... Here is a line of code I'm having problems with: Sub SingleDoor(SCell as Integer) Range("A" & SCell + 5 ":C" & SCell + 10) I know it is my syntax that is wrong. Can anyone help? I would like to select the range of cell from A5:C10 if SCell is passed as 1. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting a range in code
in his other post, he missed 2 :-)
Bob "Frank Kabel" wrote in message ... :-) last efforts before quiting working for today :-) He was really tricky also a missing apersand...) -- Regards Frank Kabel Frankfurt, Germany "Bob Phillips" schrieb im Newsbeitrag ... Hey, you even spotted his mistaken math :-) Bob "Frank Kabel" wrote in message ... Hi Range("A" & SCell + 4 &":C" & SCell + 9).select -- Regards Frank Kabel Frankfurt, Germany "JCanyoneer" schrieb im Newsbeitrag ... Here is a line of code I'm having problems with: Sub SingleDoor(SCell as Integer) Range("A" & SCell + 5 ":C" & SCell + 10) I know it is my syntax that is wrong. Can anyone help? I would like to select the range of cell from A5:C10 if SCell is passed as 1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| VBA Code for selecting row | Excel Discussion (Misc queries) | |||
| VBA Code for selecting days | Excel Programming | |||
| Selecting cells for code | Excel Programming | |||
| Selecting a PivotItem in code | Excel Programming | |||
Linear Mode
