Thread: Copying and Pasting Different Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
C01d[_7_] C01d[_7_] is offline
external usenet poster
  
Posts: 1
Default Copying and Pasting Different Formulas

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

Reply With QuoteReply With Quote