VBA Copying Formulas

[AD_Taylor]

Lets say in A1 I have a formula that has been array entered (Ctrl + Shift + Enter).
I want to copy this formula to Cell B1 but update the cell references etc. and to do this copy within VBA code.

Can I just use something like:

Range("B1").Formula = Range("A1").Formula

?

As I'm assuming that would copy the formula but not update the references?

 

[shg]

How about

Range("A1").Copy = Range("B1")

 

[shg]

Sorry, spurious equals sign:

Range("A1").Copy Range("B1")

 

[gregtx81]

I believe this will do what you want as well.

Range("B1").FormulaArray = Range("A1").FormulaR1C1

 

[gregtx81]

Can't determine how to delete.