changing from relative to absolute cell reference in multiple form

G

Guest

Is there a way to change relative cell refernces in multiple formulas from
relative to absolute all at the same time, rather than highlighting refernce
and hitting F4 and changing them one at a time. I have to change several
hundred formula references from relative to absolute.
 
A

Ardus Petus

Sub AbsFormula()
Dim rcell As Range
For Each rcell In ActiveSheet.UsedRange.SpecialCells(xlFormulas)
rcell.Formula = Application.ConvertFormula( _
rcell.Formula, xlA1, xlA1, xlAbsolute)
Next rcell
End Sub

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with converting a block of cells with Absolute and mixed references to relative references 3
Changing Multiple Cells from Relative to Absolute Functions 2
Relative, absolute & mixed references in many cells 11
Making relative references absolute 5
How to chnge 35 relative cells to 35 absolute cells at one time. 3
"Relative" Absolute Cell References in Excel 2007 4
change relative to absolute references 2
name range from absolute to relative 6

Top