Selecting a range in code

[Guest]

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.

 

[Frank Kabel]

Hi
Range("A" & SCell + 4 &":C" & SCell + 9).select

 

[Bob Phillips]

Hey, you even spotted his mistaken math

Bob

 

[Frank Kabel]

last efforts before quiting working for today

He was really tricky also a missing apersand...)

 

[Bob Phillips]

in his other post, he missed 2

Bob

last efforts before quiting working for today

He was really tricky also a missing apersand...)