Copy Formulas in One excel Workpaper to another excel Workpaper without linking

1
votes

I'm working on an Excel sheet that has 1026 cells ( 18 Columns+ 57 rows ) Each cell has a Formula.

I want to copy all Formulas for all 1026 cells and only the Formulas, and paste it in another Excel Workpaper.

I have tried using a special paste- Paste formulas and it linked me with the old workpaper which it's not what I want!

I'm only seeking to transfer the Formulas.

Any solutions ?

1
vbaexcel
Duplicated of stackoverflow.com/questions/31965152/… – Manuel Romeiro

1 Answers

2
votes

You can do it this way, without any need to copy/paste:

destinationRange.Formula = sourceRange.Formula

It copies all the formulae in the source range, as is.