Change ref type

[Matt]

Is there a simple way to change a range of absolute references to
relative?

 

[Mike H]

Mat,

Right click your sheet tab, view code and paste this in. Select the range of
data and run the code

Sub Missive()
For Each c In Selection
If c.HasFormula Then
c.Formula = Application.ConvertFormula(c.Formula, _
FromReferenceStyle:=xlA1, ToReferenceStyle:=xlA1, ToAbsolute:=xlRelative)
End If
Next
End Sub


Mike

 

[Matt]

Mike, I tried the missive code by selecting the range and running but
the formulas are still showing relative references.

the formulas look like this: ='Nov W3'!E38

Does it matter that the reference is to another sheet?

 

[Matt]

Shoot. I got it backwards. I mean relative to absolute ( ='Nov W3'!
E38 to ='Nov W3'!$E$38)