JrExcelTor
New Member
- Joined
- May 30, 2015
- Messages
- 15
Hi All,
I need a code to put at the beginning of a macro that will compare slicer values (they are text) to a list of text values in another worksheet (call it worksheet1). Basically, if the slicer value cannot be found in the list, I want the macro to kill the routine so I do not get a run time error.
I tried using on error goto however it seems to only work one time. My thinking is that this will eliminate need for error handling.
Thank you!
I need a code to put at the beginning of a macro that will compare slicer values (they are text) to a list of text values in another worksheet (call it worksheet1). Basically, if the slicer value cannot be found in the list, I want the macro to kill the routine so I do not get a run time error.
I tried using on error goto however it seems to only work one time. My thinking is that this will eliminate need for error handling.
Thank you!
