View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default error handler in macro?

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Don" schrieb im Newsbeitrag
...
Want to do a selection.find on a column. How do I return
processing to macro if selection is NOT found?

THANKS