Is value a named range somewhere, or do you want this to appear as
text to alert you to the fact that the two totals are not the same? If
the latter, then you need to enclose the word value within double
quotes, like so:
Hope this helps.
On Apr 20, 4:54 am, James W. <James XXXX@XXXXX.COM >