VBA Inserts "NM" instead of 0""

[prescient]

So I macro that should grab the existing cell formula and then wrap it with an iferror, but instead of inserting a 0 into the iferror formula it inserts "NM".

Please Login or Register  to view this content.

For example if the cell formula is "=A1+B1" and I run the macro it will insert "=iferror(A1+B1,"NM")"

[dangelor]

Try

Please Login or Register  to view this content.

[TMS]

Try:

Please Login or Register  to view this content.

Regards, TMS

[prescient]

Weird they all insert that "NM" instead. I'm clueless.

I even tried:

Please Login or Register  to view this content.

[TMS]

Please post a sample workbook.

[OnErrorGoto0]

Does this happen with all workbooks/worksheets?

[JapanDave]

I don't know if this is what you are after, but try this.

Please Login or Register  to view this content.

[prescient]

OK so If I run the macro with the hotkey setup it inserts the "NM" but if I manually launch the sub it works fine.

[TMS]

Both of these routines work when run manually, the first by selecting a range initially.

I see no reason why they would work differently from a short cut key. Unless you have changed which macro the short cut key links to, you may well be running your original code.

The second one definitely works eith Ctrl-Shift-E

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[TMS]

Forgot to mention; the only time NM appears is in the existing formula.

Regards, TMS

[OnErrorGoto0]

The macro in the workbook does not appear to be assigned to a shortcut key.