View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Len Len is offline
external usenet poster
 
Posts: 162
Default Error Cell "#N/A"

On May 20, 12:16*am, "Rick Rothstein \(MVP - VB\)"
wrote:
Rick, that is the way I was going to suggest doing it as well, but he
mentioned that this was only for the #N/As, so I was assuming that he
could possibly have other errors in the sheet. *Without the loop, it
would change all of the errors to 0.00, not just the #N/As.


Yes, that eventually dawned on me... your message and my correction message
"crossed in the mail".

Rick


Hi ,

Thanks all of you, it works

Regards
Len