Variable in a range.

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi. thanks for the previous help. I have been able to continue merrily until
the point where I would like to use a variable in a range:
destination:=range("A10:A" & <variable>) etc
How can I get a variable into the 1st part? the range will always start in
column A but the start and end row may vary.

tx,Chris
 
another approach could be

Range("A" & var1).Resize(var2-Var1+1,1)

or

Range(cells(var1,1),cells(var2,1))
 
I haven't been following your previous postings. I assume that you are
trying to vary the starting and ending cells.

Destination:=Range("A" & var1 & ":A" & var2)

Sub VariableAddress()
Dim var1 As Long, var2 As Long
Dim rngV As Range
var1 = 10: var2 = 15
Set rngV = Range("A" & var1 & ":A" & var2)
Debug.Print rngV.Address
End Sub

Tested using Excel 97SR2 on Windows 98SE,

HTH
Paul
 
Back
Top