Worksheets(1).Range("F" & J, "O" & J).copy _
Worksheets(4).Range("C" & K)


if your source contains formulas, but you want to only transfer the
resulting values

Worksheets(1).Range("F" & J, "O" & J).copy
Worksheets(4).Range("C" & K).PasteSpecial xlValues
Worksheets(4).Range("C" & K).PasteSpecial xlFormats

--
Regards,
Tom Ogilvy


"chick-racer" wrote in message
...
thanks alot. I dont know why i didnt think of trying that.
Now, is there a line i can add in order to keep the same formatting. I
guess what i'm trying to say is, I have some cells with shading and/or
colored font, is there a way to make it look the same when it's copied
to the next worksheet?

Much appreciated.


---
Message posted from http://www.ExcelForum.com/