Thread: On Error? Creates 1 missing worksheet then never detects any other missing worksheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Craigm[_36_] Craigm[_36_] is offline
external usenet poster
  
Posts: 1
Default On Error? Creates 1 missing worksheet then never detects any other missing worksheets

Set wsSheet = Nothing

I had to put the line in both the "If" and "Else" conditions. Now it
works correctly.

Thank You, Rob!


--
Craigm
------------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
View this thread: http://www.excelforum.com/showthread...hreadid=391774

Reply With QuoteReply With Quote