Changing many cells from absolute reference to relative

G

Guest

Yesterday I changed all the formulas from relative to absolute references and
now I need to change them back. I used this macro to make them absolute.
Sub Absolute()
Dim cell As Range
For Each cell In Selection
If cell.HasFormula Then
cell.Formula = Application.ConvertFormula(cell.Formula, _
xlA1, xlA1, xlAbsolute)
End If
Next
End Sub
 
G

Guest

I simply changed "Absolute" to "Relative" in the convert formula and it
worked. Thanks
 
G

Gord Dibben

Woody

Yesterday I gave you four macros.

Use the Relative one.

Gord Dibben Excel MVP
 

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

Changing cell references in a Range to Absolute 1
I need more help with Absolute Reference 4
Disapearing formulas 1
Update References To Absolute 1
Range of cells: Convert relative reference into absolute 5
Change a cell reference from relative to absolute 2
Excel 2002: changing link formula from absolute to relative 3
How do I copy a combobox to many cells with relative reference? 1

Top