Hi Howard,

The only real issue is how to programmatically tell Excel to ignore the
"error" for those cells.
Is there a way to do that?

That would be the Errors collection for the range:

rng.Errors(XlErrorChecks.xlNumberAsText).Ignore = True

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev