Change from Absolute to Relative references
Posted by Ron on August 08, 2001 9:15 AM
Does anyone know a quick way to change from absolute to relative cell references for a range of cells quickly? Perhaps this can be accomplished through VBA? I'd like the ability to choose a range of cells and change the type of cell reference for the entire range. Thanks in advance for any suggestions.
Posted by Russell Hauf on August 08, 2001 10:01 AM
A quick way without VBA is to hit the F4 key while you are entering the formula. This will toggle between the 4 options (absolute references for both rows and columns, absolute for rows only, absolute for columns only, and relative).
Not sure offhand how I would do this with code, but I'll take a look and see what I find.
Hope this helps,
Russell
Posted by Russell Hauf on August 08, 2001 10:10 AM
Found the ConvertFormula method. Try these 2 links (well, not really links):
http://support.microsoft.com/support/kb/articles/Q116/0/28.ASP
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaxl10/html/xlmthConvertFormula.asp
