Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable in a range.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable in a range.
another approach could be
Range("A" & var1).Resize(var2-Var1+1,1) or Range(cells(var1,1),cells(var2,1)) -- Regards, Tom Ogilvy "Chris" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable in a range.
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 -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Range | Excel Discussion (Misc queries) | |||
Variable range in VB | Excel Discussion (Misc queries) | |||
Variable in Range | Excel Discussion (Misc queries) | |||
variable range: l just can't get there! | Excel Programming | |||
Problem trying to us a range variable as an array variable | Excel Programming |