Using variables to select a range

[Guest]

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.

 

[Tim Williams]

close!

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

Tim

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.