Make relative references absolute - many macros not working

[martinpgibson]

Hi there,

I know there are many macros on the internet that will turn relative references into absolute, but I am getting all sorts of issues using them on my cells. I tend to get value errors or simply nothing happens. Most of them work by selecting the cells you want to make absolute and running the macro, but I am just not having any luck. My cells are all filled with this formula:

Please Login or Register  to view this content.

I know it's a big formula but there is nothing crazy going on. Does anyone have any good macros that might work. Thanks in advance!

[martindwilson]

i had a quicklook at a few and they all seem to only work if total length of formula is less than 255 characters yours is 375 +=