View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_135_] joel[_135_] is offline
external usenet poster
 
Posts: 1
Default Help with Traping (I believe) a no-Find() error throuh the us of a seemingly unrelated functiom


You can simulate an error using the error statement

Error errornumber


So if you want to trap on an condition put this in an IF statement

if isnumeric() then Error 123


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149399