Ignore Type mismatch error

I was trying to write data from Excel to an output file. It works fine, except if there are no values in a cell with an embedded formula. Is there VB code that I could add to the macro, so that it would ignore the #N/A error in the cell and continue writing data from cells that contain data only? thanks

Hello mixel,

You could trap the specific error using either the On Error GoTo or On Error Resume Next statement. Most likely you can avoid generating an error at all. Either way, you should post your code.

Sincerely,
Leith Ross

Thanks, Leith Ross.
Here is the code:

Please Login or Register  to view this content.

Hello mixel,

Where are you getting the "N/A" error? That is worksheet formula error.

Sincerely,
Leith Ross

As you see in the attachment, the #N/A error was coming from the formula (see below) in that worksheet cell.

Please Login or Register  to view this content.

I wanted to continue writing data, even if there is no data in a cell.

Hello mixel,

Actually, I don't see any formulas anywhere in your attachment. This is all very confusing. If you want to get an answer to problem, post your complete workbook for review.

Sincerely,
Leith Ross

I used the On Error GoTo and it worked fine. Thanks for the tip.