View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Sheet Jack Sheet is offline
external usenet poster
 
Posts: 47
Default Deleting names with errors

Hi all

Is there a quick and easy VBA method of deleting all names that contain
errors?
I don't mean EVALUATE to errors, that would be too difficult.
I mean if I have a name that contains
=#REF!$A$1:$A$100
or
=#N/A
etc

Thanks

--
Return email address is not as DEEP as it appears