C01d, thanks for responding. If I use the copy function, I will have to have
the macro go back and forth to Sheet 1. For example, I would have to have it
copy the first formula, paste it in Sheet2, go back to Sheet1, copy the
second formula and paste it in Sheet2. I'm trying to come up with a way which
would store all the formulas, so that it would not have to go back to
Sheet1. Would you happen to know of a way to do that?

Thanks a lot for your help!

Magnivy
"C01d" wrote:


The Range class has two functions that you could try using, namely, copy
and pastespecial.

Your code would look similar to this:
rng1.Copy
rng5.PasteSpecial(xlPasteFormulas)


--
C01d
------------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=548157