I think then you will need to use R1C1 reference style formula's, so for
example = RC[-1] instead of = A1
etc.
The other option is to manipulate the formula string
by only leaving in bits that can't refer to a range, but that
gets a bit complex.

RBS


"ra" wrote in message
ups.com...
Thanks RBS, that has provided a good start :)

It now highlights all cells that are different, however ideally I do
not mind if the result (value) is different just if the underlying
formula is. For example if a formula has been copied accross row 3 say
from column A to D and then a new formula is entered from column E- I
want (if possible) the code to highlight cell A3 and then the new
formula cell in column E3.

I hope that makes sense!
cheers Ra