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.

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.

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.

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.

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.