Use Macro to Copy and paste formulas from one spreadsheet to anoth

B

bevchapman

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?
 
M

Mike H

Hi,

Maybe this

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

Mike
 
J

Jacob Skaria

Dim ws1 as Worksheet, ws2 as Worksheet

'Saved workbook will have extension like Workbooks("Book1.xls")
Set ws1 = Workbooks("Book1").Sheets("Sheet1")
Set ws2 = Workbooks("Book2").Sheets("Sheet1")

ws1.Range("A1:B10").Copy
ws2.Range("A1").PasteSpecial Paste:=xlPasteFormulas
Application.CutCopyMode = False

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Macro to Copy Formula from one Workbook to another 4
Auto Populate One Pages from spreadsheet 0
How to paste this down? 3
problems getting this macro to work 8
Paste Link and Link Text From Browser to Word 0
Word macro that can call cells out of Excel for a find and replace 0
Copy and paste slide from one presentation to another presentation gives an error 2
Visio shape text disappears upon copy paste 1

Top