Hi Guys,

I am really new to VB and need some help. The code I am using below works great however it does a retrieve on every tab. I would like to exclude two tabs from the the retrieve called 'table' and 'list'.

Sub ESSBASE_UPDATE()
Dim wsName As String
Dim MyError As Boolean
On Error GoTo NoEssbase
'-------------------------
For Each ws In Worksheets
wsName = ws.Name
MyError = False
Application.Goto Reference:=ws.Range("A1:AD29")
If Not MyError Then Application.Run Macro:="EssMenuRetrieve"
Next
'--------------------------
On Error GoTo 0
Exit Sub
'--------------------------
NoEssbase:
MsgBox ("Worksheet called '" & wsName & "' has no essbase range.")
MyError = True
Resume Next
End Sub
'---------------------------------------


Any help would be really appreciated.

Thanks