On 6 Oct, 00:25, "Max" wrote:
You gave me the clue - it's a merged cell that it is referencing
and not actually a range

well, I think those are ranges that's captured in your posted formula. but
glad it got you going. anyway, the general refrain is to avoid using merged
cells
--
Max
Singaporehttp://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
--- *

Yes, well clicking on the merged cell captured it as a range. Now I've
taken that out, all is well

Cheers