Absolutes in Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a faster way to change a bunch of formulas to have absolute values,
instead of going into each one and doing the F4?

~Steph
 
Steph,

Select the cells with formulas, and run the macro below.

HTH,
Bernie
MS Excel MVP


Sub ConvertToAbsoluteReferences()
Dim myCell As Range
Dim storedCalc As Variant
With Application
storedCalc = .Calculation
.ScreenUpdating = False
.EnableEvents = False
.Calculation = xlCalculationManual
For Each myCell In Intersect(Selection, Selection.SpecialCells(xlCellTypeFormulas))
myCell.Formula = Application.ConvertFormula( _
myCell.Formula, xlA1, xlA1, xlAbsolute)
Next myCell
.ScreenUpdating = True
.EnableEvents = True
.Calculation = storedCalc
End With
End Sub
 
You must log in or register to reply here.

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

how to apply absolute cell referencing to multiple cells at once? 2
changing from relative to absolute cell reference in multiple form 1
Absolute formulas 4
Relative, absolute & mixed references in many cells 11
Worksheet relative reference 3
copying absolute formulas 1
Help with converting a block of cells with Absolute and mixed references to relative references 3
How to chnge 35 relative cells to 35 absolute cells at one time. 3

Back
Top