Chg Absolute to Relative

[Adresmith]

I am in need of VBA that will convert a selected cell's formula from
using absolute references to using relative references. I only want it
to change the active cell. Please help I know very little VBA.

Thanks!

 

[Frank Kabel]

Hi
have a look at the
ConvertFormula
method in the vBA help