Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! -- Adresmith ------------------------------------------------------------------------ Adresmith's Profile: http://www.excelforum.com/member.php...fo&userid=9131 View this thread: http://www.excelforum.com/showthread...hreadid=273679 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
absolute & relative references | Excel Discussion (Misc queries) | |||
Relative and absolute hyperlinks | New Users to Excel | |||
name range from absolute to relative | Excel Worksheet Functions | |||
changing relative to absolute | Excel Discussion (Misc queries) | |||
Absolute vs Relative path | Excel Discussion (Misc queries) |