You specifically looked through formulas by using: xlCellTypeFormulas

xlcelltypeconstants
would have been my next try.

DA wrote:

Ok, I think I figured it out. It looks like it would need to be a
real #N/A, not just a text string.

Never mind but thanks!
D

--

Dave Peterson