One More Visual Basic Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lj - 20 Dec 2006 18:48 GMT

Hi, I'm creating a macro and wanted to know if there's a way (and what
the syntax would be) to have the macro look to see if a particular
worksheet exists and if it does delete it and if it doesn't exisit to
continue moving on in the macro. Thanks for your help.

Reply to this Message

Bob Phillips - 20 Dec 2006 19:06 GMT

Dim sh As Worksheet

On Error Resume Next
Set sh = Worksheets("Sheet to be deleted"
On Error Goto 0
If Not sh Is Nothing Then
Application.DisplayAlerts = False
sh.delete
Application.DisplayAlrerts = True
End If

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> Hi, I'm creating a macro and wanted to know if there's a way (and what
> the syntax would be) to have the macro look to see if a particular
> worksheet exists and if it does delete it and if it doesn't exisit to
> continue moving on in the macro. Thanks for your help.

Reply to this Message

lj - 20 Dec 2006 19:34 GMT

Thanks, this was exactly what i was looking for!

> Dim sh As Worksheet
>
[quoted text clipped - 19 lines]
> > worksheet exists and if it does delete it and if it doesn't exisit to
> > continue moving on in the macro. Thanks for your help.

Reply to this Message