Formula macro

[dtrom26]

Hi,

I have the following macro that works perfect to copy cells from Sheet "Parameters" to all active sheets. However, a lot of the cells contain formulas that require 'CTRL+SHIFT+ENTER' to work. Is there a way the macro below can be modified so that such macros automatically work when copied, rather than me doing the cells individually which would take a long time!

Thank you

Sub dtrom()
Dim ws As Worksheet


For Each ws In Worksheets
ws.Range("N1:AG3000").Formula = Sheets("Parameters").Range("N1:AG3000").Formula
Next ws


End Sub

[daffodil11]

Please Login or Register  to view this content.

[FDibbins]

My VBA is weak, but surely if you copy a formula - regular or array - it will get copied the same wahy doinfg it manually, or via a macro? It is a copy/paste function?

[dtrom26]

Please Login or Register  to view this content.

Hi

Thank you for this. However, when I run, I get the folllowing error:

"Object doesn't support this property or method"

When I debut it highlights

ws.Range("N1:AG3000").ArrayFormula = Sheets("Parameters").Range("N1:AG3000").ArrayFormula

Any help please?

Thank you!

[Trebor76]

Coping array formulas is a little tricky. Try shg's suggested solution from here

[Catman50]

Try This method

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Change the whole macro by

Please Login or Register  to view this content.