Thread: Creating Sheets in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
dominicb[_59_] dominicb[_59_] is offline
external usenet poster
  
Posts: 1
Default Creating Sheets in VBA

Good evening Cmk18

If you try to navigate to a non existent sheet in VBA an error will be
thrown up. Why not trap the error (such as On Error Goto NewSheet) and
then at the NewSheet: label, create the new sheet. If an error doesn't
occur, the sheet exists and you can Exit Sub.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=386196

Reply With QuoteReply With Quote