Thread: How do I find and replace "values" (like #N/A) in a worksheet?
View Single Post
  #4   Report Post  
JustinLabenne JustinLabenne is offline
Junior Member
  
Location: Ohio
Posts: 19
Default
I made a small utility to do this programmatically. Assuming your formula returns correct results and has correct syntax, this utility adds an ISERROR OR ISNA to cell error values. It also allows for specifying text or characters to be used in the errors place, and for the ISEROR and ISNA to be programmatically removed from the formula

You can download it here

http://jlxl.net/Excel/downloads.html
__________________
Justin Labenne
www.jlxl.net
Last edited by JustinLabenne : June 12th 05 at 12:15 AM Reason: typo
Reply With QuoteReply With Quote