You need to set a variable to the result of your line of code, or
assign a value to it. E.g.,


Dim Rng As Range
Set Rng = range("a1").end(xldown).offset(1,0)
' or
range("a1").end(xldown).offset(1,0) = 123


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Alex Martins" wrote in
message
...
range("a1").end(xldown).offset(1,0)

This works, but it asks me to put and "="...how can I make this
work to
paste a previous selection?

Many thanks in advance
Alex