Absolute references in a cell
I have 30 pairs of cell refs in a cell that need to be converted to all
Absolutes. I need to do this over 60 cells. Please can someone provide a
handy macro that will run this conversion - I have tried some I found in this
forum but they cause #VALUE errors.
Cell example: =(x*y)+(a*b)+(c*d)....etc
Thanks
|