I'm trying to handle some errors using err.Number such as in:
This works in excel 2010 but in 2016, I get a compile error with "expected function or variable", so the code won't execute at all.![]()
MsgBox Err.Number & " " & Err.Description
I hope it's just something that needs enabling in 2016 somewhere, otherwise when we move onto 2016 as a company, a large amount of automation will fail.
Is anyone using 2016 and able to use this function?
Bookmarks