Excel macro to copy formula from selected cell range

Can anyone help me to create a VB code for copying Excel formulas from V3:AE3 Cells and paste it over V:AE columns.

@pari_patel - Have you tried this activity already?

Note: This should be used inside excel application scope…

I will definitely try that one. IF I want to paste formula from V3:AE3 cell to entire V:AE column then see below image and let me know if it is wrong.


Give it a try and let us know if you get any error or if this didn’t meet your requirement…

1 Like

This is no working… It is copying in the header and from header to V3 only… Rest of the rows are not copying.