View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JCanyoneer JCanyoneer is offline
external usenet poster
 
Posts: 56
Default 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.