changing from relative to absolute references

[brian.baker13]

Hi

I have 8 sheets of relative references that I need to change to
absolute references. Can I change these in one go please?

Thanks

Brian

 

[Tyro]

Out of curiosity, why do you need to do this?

Tyro

 

[Bob Phillips]

Dim sh As Worksheet
Dim cell As Range

For Each sh In ActiveWorkbook.Worksheets

For Each cell In sh.UsedRange

If cell.HasFormula Then

cell.Formula = Application.ConvertFormula( _
cell.Formula, toabsolute:=xlAbsolute)
End If
Next cell
Next sh


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)