Chg Absolute to Relative

  • Thread starter Thread starter Adresmith
  • Start date Start date
A

Adresmith

I am in need of VBA that will convert a selected cell's formula fro
using absolute references to using relative references. I only want i
to change the active cell. Please help I know very little VBA.

Thanks! :confused
 
With ActiveCell
.Formula = Application.ConvertFormula(.Formula, xlA1, xlA1,
xlRelative)
End With
 

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

Absolute to Relative Referencing 3
Chg Absolute to Relative 1
.ReferenceStyle=xlA1 Converting Relative to Absolute References? 3
Module to make all absolute references relative 3
Excel How to code in excel vba 2007 using absolute refernce for cells 1
Absolute or Relative reference - no longer a choice! 5
absolute relative reference 2
make formulas from relative to absolute 4

Back
Top