Copy same formula into other columns

[Vishal2050]

<article>

Greetings!!

I am having formulas into columns but those formulas are not freeze with "$"

I have to copy the same formula from those columns to other columns. But while doing so cells reference get changed as those are not freeze with "$".

I do not want to freeze with "$" but want to copy the exact formula into other column

Any suggestion

Regards
Neeraj Kumar Agarwal​

</article>

 

[bellman101]

Hi Neeraj,

May I ask why you would not want to freeze the cell references? as this will achieve exactly the same thing?

You could always remove them after with a Find "$" and Replace with "".

Cheers
JB

 

[Vishal2050]

Hi, I just want to know, if there any possibility of doing so.

 

[bellman101]

Well yes, there are a few ways. the tedious method: instead of the cell, copy the formula out of the formula bar and paste it.

Or this one-liner of vba code will do it:

Sub CopyIdenticalFormula

    Range("B1:B100").value = Range("A1:A100").formula

End Sub

Cheers
JB