Verify Sheet existence

          Method 1

Function isSheetExists()

                    On Error Resume Next

                    isSheetExists=True

                    Err.Clear

                    Set objSheet=Datatable.GetSheet("Global")

                    If Err.Number <>0 Then

                             isSheetExists=False

                    End If

                    msgbox isSheetExists

          End Function

          Call isSheetExists()

          Method 2

          shtCnt=Datatable.GetSheetCount

          For shtNum=1 to shtCnt

                   If Datatable.GetSheet(shtNum).Name=”Action1” Then

                             Msgbox “Action 1 sheet exist”

                   End If

          Next  

Contributed by: Vamshi Gowtham
m.vamsigowtham@gmail.com