Get instant live expert help on I need help with excel vba iserror

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hello. I am having issues with the ISERROR function
Solved by B. A. in 16 mins
Why does 2013 & 2016 not resolve VBA match. This statement works in 2007 (where I started my code) but always results in 1 for 2013 & 2016. MyHoliday = -1 * IsError((Application.Match(Cells(3, J).Value, Range("HolidayNotEaster").Value, 0))) Naturally HolidayNotEaster is a list of dates and Cells(3, J) is also a date
Solved by Z. W. in 30 mins
Solved by A. H. in 14 mins
=IF(ISERROR(CI48/CI5),"-",(CI48/CI5)) what is this formula calculating? is it making CI48/CI5 negative?
Solved by A. J. in 26 mins
I want to compare 2 columns with this formula = IF (ISERROR (MATCH (A1, $ C $ 1: $ C $ 5.0)), "", A1)
Solved by G. J. in 21 mins