Thread: trapping error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jeff Harbin[_3_] Jeff Harbin[_3_] is offline
external usenet poster
 
Posts: 2
Default trapping error

I didn't go through all your code but the MsgBox located after your NoFile label should NOT have the parentheses around the arguments. This is only necessary when setting the response of MsgBox to some value. You get an error normally when you try using MsgBox this way. Could that be why your error trapping isn't working

HTH