Change ref type

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Is there a simple way to change a range of absolute references to
relative?
 
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
 
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?
 
Shoot. I got it backwards. I mean relative to absolute ( ='Nov W3'!
E38 to ='Nov W3'!$E$38)
 
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

Copying with transpose and VB code 1
Range of cells: Convert relative reference into absolute 5
Changing relative references 1
GETPIVOTDATA #REF! error XL2003/2010 1
Changing ref's within formulas without having to retype each one. 3
change the reference type of multiple formulas 1
changing relative to absolute 2
#Ref! 1

Back
Top