Chg Absolute to Relative
 

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

Thanks! :confused

--
Adresmit
-----------------------------------------------------------------------
Adresmith's Profile: http://www.excelforum.com/member.php...nfo&userid=913
View this thread: http://www.excelforum.com/showthread.php?threadid=27367

Chg Absolute to Relative
 

With ActiveCell
.Formula = Application.ConvertFormula(.Formula, xlA1, xlA1,
xlRelative)
End With

--

HTH

RP

"Adresmith" wrote in message
...

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! :confused:


--
Adresmith
------------------------------------------------------------------------
Adresmith's Profile:
http://www.excelforum.com/member.php...fo&userid=9131
View this thread: http://www.excelforum.com/showthread...hreadid=273679