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