KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Q: How do i determine if an error is in any cell in the entire workbook with Excel VBA? Normally errors will be divide by 0 or #value errors, but this list is not exhaustive (or is it? - i don't know if more exist) Is there a way to determine if a cell contains an error then to skip over further processing in my script without spitting out a debug/warning/error message. something such like if value in current.Workbook.cell is error then go to <jump> OR if value in old.Workbook.cell is error then go to <jump> where jump is a marker at the end of an if statement but within a loop. the script compares values between two workbooks and updates the current workbook with colours to show difference. I have no VBA experience at all. but i get the gist of the script i have been given. thank you kindly.
Tags (comma-separated)
Save Edits
Cancel