Look at the ConvertFormula method in VBA help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"loudun" wrote in message
...
Each cell in my worksheet contains long formulas such as this:
if(or(A2=1,B2=1, C2=1,D2=1..... I want to copy the formula to another cell
but I want all cell references to be absolute. How do I convert the
relative
addressing to absolute addressing without manually adding $ to each
reference?