VBA Error Handler: place zero in error cell

**lostest** · 11-24-2015, 07:13 PM

How do I adjust the code below to place a zero in cells excel calculates as errors?

Please Login or Register  to view this content.

**stnkynts** · 11-24-2015, 07:25 PM

I believe (could be wrong) the way you have the code written only one cell will get a value of zero. If you are wanting all the error cells with a zero you will need to amend your code. Here is the answer to your initial question

Please Login or Register  to view this content.

**lostest** · 11-24-2015, 07:33 PM

You are absolutely right, I do want a zero in all error cells.

How should the code go?

**stnkynts** · 11-24-2015, 08:19 PM

Maybe this:

Please Login or Register  to view this content.

**lostest** · 11-26-2015, 06:10 PM

Thanks stnkynts.

Here is another solution I came up with.

Please Login or Register  to view this content.

VBA Error Handler: place zero in error cell

LinkBack

Thread Tools

Rate This Thread

Display

VBA Error Handler: place zero in error cell

Re: VBA Error Handler: place zero in error cell

Re: VBA Error Handler: place zero in error cell

Re: VBA Error Handler: place zero in error cell

Re: VBA Error Handler: place zero in error cell

Thread Information

Users Browsing this Thread

Similar Threads

'While' function inside of error handler giving an error/failing

[SOLVED] Need error handler code to avoid pivot table refreshing error if no data is available

Getting Run-time Error 91. Error handler not working.

Error Handler Runs Without Error

Error Handler for Run-time error '9'

[SOLVED] Form Err.Raise error not trapped by entry procedure error handler

Error Handler and Error 1004

Bookmarks

Bookmarks

Posting Permissions