Copy range, offset, then paste

Hello,

I'm trying to copy a range, specified by an offset, then PasteSpecial that range to yet another location specified by an offset.

This is the code I have so far, which does not attempt to find the range to copy via an offset. But I need it to do that eventually.

Please Login or Register  to view this content.

In this code, it should be copying the range V3:AE3, then pasting the formulas in the same columns, 6 rows below. Right now, I'm getting an error highlighting the first row. I would assume it's just the syntax, but I don't know....

I've searched upside and down, seen a bunch of different examples, but none seem to do this. (At least to these noob eyes...)

Thanks!
Willys

Ha!

Thank you very much Stephen.

Can you help me with making the selected range offset from the active cell?

EDIT: Actually, the copy range can always be "A3:AE3", it's the paste that needs to be offset from the active cell.