D Don Oct 6, 2004 #1 Want to do a selection.find on a column. How do I return processing to macro if selection is NOT found? THANKS
Want to do a selection.find on a column. How do I return processing to macro if selection is NOT found? THANKS
F Frank Kabel Oct 6, 2004 #2 Hi try dim c as range on error resume next set C = range("A:A").find .... on error goto 0 if not c is nothing then 'your code end if
Hi try dim c as range on error resume next set C = range("A:A").find .... on error goto 0 if not c is nothing then 'your code end if
P Pete McCosh Oct 6, 2004 #3 Enclose the relevant code in the following: On error Resume Next ...Your code here.. On error GoTo 0 The first line forces execution to continue from the next line if an error occurs and the second returns to normal error-trapping. You might want to make sure the rest of the code in this block is robust before doing this, or you may end up with some pretty wild results... Cheers, Pete
Enclose the relevant code in the following: On error Resume Next ...Your code here.. On error GoTo 0 The first line forces execution to continue from the next line if an error occurs and the second returns to normal error-trapping. You might want to make sure the rest of the code in this block is robust before doing this, or you may end up with some pretty wild results... Cheers, Pete
