Using variables to select a range
 

I am trying to pull a number from a cell and use it to select a range of cells

Dim days as integer

days = range("A1").value

range(B1:C & days).select

what is the exact syntax including any other line of code required. Assume I know nothing.

Using variables to select a range
 

close!

Try
range("B1:C" & days).select

Tim

"Marc" wrote in message
...
I am trying to pull a number from a cell and use it to select a range of
cells

Dim days as integer

days = range("A1").value

range(B1:C & days).select

what is the exact syntax including any other line of code required.
Assume I know nothing.