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