Hi!

Are the blanks cells scattered within the range or are they all at the end
of the range?

Did you try Debra's suggestion of using a dynamic range? If so, what does
you formula look like?

Biff

"Hayley" wrote in message
...
The range is an array formula so I had copy it down enough rows to allow
for
the largest number of items. So while the result is blank the cell has a
formula. So your suggestion didn't work.
--
Hayley