Absolute Cell References

[Michelle.King]

Is there a way (without writing a macro) to change cell references from relative to absolute for a selected range of cells?

 

[T. Valko]

Is there a way (without writing a macro) to change cell references from relative to absolute for a selected range of cells?

Only if EVERY cell reference to be changed is exactly the same. Then you could use Edit>Replace.

But, I'm guessing that your cell refs are not all exactly the same and in that case the answer to your question is no.

 

[Michelle.King]

Thank you for your response. As you suspected, every cell reference is not the same.

I suck at writing macros in Excel. I don't have a problem in Word but for some reason, in Excel, they never work. Unless you happen to have advice on how to get a macro to work in Excel... That would be super!

Thanks again!

~Michelle

 

[jeffreybrown]

Hi Michelle,

I think this might be what you need...

http://www.ozgrid.com/VBA/formula-ref-change.htm

 

[T. Valko]

Thank you for your response. As you suspected, every cell reference is not the same.

I suck at writing macros in Excel. I don't have a problem in Word but for some reason, in Excel, they never work. Unless you happen to have advice on how to get a macro to work in Excel... That would be super!

Thanks again!

~Michelle

Here you go:

http://tinyurl.com/4vt6r47