VBA - Paste-Special Formula for Cells with Values

[jacksparrow]

I'm looking for some VBA code that will allow me to do the following:

In a given worksheet, for each cell that has data in it (numbers or text), I want to paste-special the formula that is in the clipboard.

Any suggestions?

 

[goldfish]

I'm looking for some VBA code that will allow me to do the following:

In a given worksheet, for each cell that has data in it (numbers or text), I want to paste-special the formula that is in the clipboard.

Any suggestions?

This will replace any constants with numbers or text in the worksheet:

Cells.SpecialCells(xlCellTypeConstants, 3).PasteSpecial Paste:=xlPasteFormulas

 

[jacksparrow]

Thanks, you just saved me hours of work!

 

[gsrikanth]

This will replace any constants with numbers or text in the worksheet:

Cells.SpecialCells(xlCellTypeConstants, 3).PasteSpecial Paste:=xlPasteFormulas

i need full code