Sorry I mean copy from doc1 range a2:f2 to doc2 range a1:f1

"sebastienm" wrote:

to a new file
do you mean new book or a new sheet withing the same book?

In any case, use the syntax:
range.cut destination_range
eg:
workbooks("my book.xls").Worksheets("sheet1").Range("a1:f2").Cut _
workbooks("book2").Worksheets("sheet2").Range("a1" )
In this case it is from a book to another book.

I you want to copy and not cut, use the Copy method. It works the same way.

Regards,
Sébastien
"Weasel" wrote:

I'm trying to move a range of cells to a new file and new range I can't get
it to work.

eg.
doc name: sheet1
range: a2:f2
new file: sheet2
new range: a1:f1

Any help would be appreciated