I could have messed it up. The way dave posted worked great. thanks everyone
for your help.

"Bob Phillips" wrote:



"Tim Coddington" wrote in message
...
Was you certain to include the 'NOT' in the If IsError statement where I
added it in?

By doing so, the do nothing statement could be removed