The column that I needed the error message suppression for needs to be Text as the value can be "09" or "AB" etc.

I also don't think it's a good idea to turn the error messages off for the entire spreadsheet. In my situation the program is a one time deal. While testing, I'll comment out that line and when I do the final run I'll un-comment it out.

I'll do a bit more research on it. The macro recording suggestion helped a lot.

Thanks for all your comments.

The recording tool is very useful.
I don't know why you use: Application.ErrorCheckingOptions.BackgroundCheckin g = False. Unless Excel2002 doesn't support my suggestion.

To test what happens when using: Application.ErrorCheckingOptions.NumberAsText = False try this on an empty sheet:

ColA - format it as text
ColB - format it as numbers

Enter 09 i a cell in col A to C and then run my suggestion. You'll see, that only colA is changing (the warning disappears). The two remaining colums are unchanged.

Therefore, you actually have full control over your data, whether disabling the NumberAsText or not.

Yes, you are correct. I tried it using the NumberAsText = False and the warning message disappeared just for that column.

Thank you :-)