Excel tips, tricks and tutorials for the intermediate to advanced user in recording macros, writing scripts in VBA, and creating user-defined functions while optimizing performance.
Highlight fields in vba rather than conditional formatting
Ever wanted to quickly highlight cells where the values are not found in another list? Here is an example of how VBA can accomplish just that!
Notice that there is an error handling used 'On Error Resume Next'? If you run this macro without it you will have problems but this statement allows the script to continue on even though the error exists!
No comments:
Post a Comment