Absolute Cell Reference

[ShaneBell]

I have a spread sheet with mulitple cell references in it.
How can I globally change all of the cell references to be absolute references without manually changing each one?

[VBA Noob]

Here some code I found on a quick search.

Try the top one. Press Alt + F11 then insert module. Paste in the Sub Absolute code. Close VB editor then select the area then press Alt + F8 then click run Absolute code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob