Thread: Use Macro to Copy and paste formulas from one spreadsheet to anoth
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Use Macro to Copy and paste formulas from one spreadsheet to anoth
Hi,

Maybe this

Sheets("Sheet1").Range("A1:B10").Copy
Sheets("Sheet2").Range("A1").PasteSpecial Paste:=xlPasteFormulas

Mike

"bevchapman" wrote:

I am trying to copy and paste a block of cells from one spreadsheet to
another. The original file is formulas and the destination cells must be the
same formula.

any suggestions on how to add this into a macro?
Reply With QuoteReply With Quote