Absolute Cell References

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

Is there a method or tool that will make cell references
absolute automatically?

I have a notebook with many pages that refer to the same
locations on each page, I need the cell references to be
absolute without having to edit each cell/formula.
 
As near as I can tell, you are asking how you can enter formulas as relative
and have them converted to absolute. If you are not asking that, then the
anser is to enter them as absolute. If you are, then you can use the change
event to convert the formula when you enter it. You can also write a macro
to convert existing formulas to absolute.

Look in help at
Application.Convertformula
 
An additional thought is to use R1C1 reference style. In R1C1 style, the
easier entry is absolute, so that might answer the mail of being
automatically.
 
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

Change Selected cells references 2
.ReferenceStyle=xlA1 Converting Relative to Absolute References? 3
VBA r1c1 absolute previous row in formula 3
Absolute to Relative Referencing 3
How to specify an absolute cell ref in FormulaR1C1 1
absolute reference r1c1 code 1
Problem with a loop and column references 27
using sum function after offset 8

Back
Top