Using variables to select a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
close!

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

Tim

Marc said:
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.
Click to expand...
Assume I know nothing.
 
Back
Top