VBA Copy Formula ?

[Pinaceous]

Hi All,

In using Excel 2013, how do I copy a formula straight down a Column on command by a macro?

I could use a recorded macro but I'm sure there's a faster way.

Where the formula is "='whatever'" pasting it down Column C:2 to C:573.

Many thanks in advance.

R/
-Pin

 

[Michael M]

Assuming the formula is a simple SUM of A2 +B2
try

Range("C2:C573").formula = "=Sum(A2:B2)"

 

[Pinaceous]

Hi Michael M,

I really do appreciate you providing me this code, as I am using this in a series with other codes, as this will really help.

Thanks very much!

R/
Pin

 

[Michael M]

Pleasure...

 

[Pinaceous]

Hey Michael,

I know its been awhile, but, let say your formula was from 'Sheet 1' 'cell' '1A' is to equal 'Sheet 2''cell' '1A'? So the formula in 'Sheet 2' 'cell' '1A' is '=Sheet1!A1'.

Could this formula be inserted in your formula above, so then the next 'Sheet 1' 'cell' '2A' could equal 'Sheet 2' '2A', then this formula could be of 'Sheet 2' 'cell' '2A' being '=Sheet1!A2'; and so on over a specified area?

Thanks,

-Pin