How do I check to see if a sheet is present?

[A[L]C]

Hi,

In excel 97, I need to check if a sheet called 'Template_Info' is present. If it isnt then a messagebox saying that is needed. if it is, then I have a procedure which I need to put afterwards which checks some values in the sheet.

Any help on this will be greatly appreciated.

Regards
Paul

[peet]

Dim i As Integer
    Dim bTemplInfSheetExist As Boolean
    For i = 1 To Application.Sheets.Count
        If Application.Sheets(i).Name = "Template_Info" Then
            bTemplInfSheetExist = True
            Exit For
        End If
        'MsgBox Application.Sheets(i).Name
    Next i

something like that ?

[A[L]C]

that works great! thanks a lot

btw.... if i wanted you for technical help, how much would you charge??

[peet]

your welcome.

It would depend on type of work, amount of work....

well this is free, so maybe posting problems here are the best way to get help

[A[L]C]

well basically, ive been taken on as a modern apprentice by EDS. Im doing data manipulation with VBA in access and excel. Although Ive learnt basic VBA, theres still stuff I dont know..... so I need someone to ask for help.

I think ill just post questions here, as they seem to get answered very quickly

Thanks a lot
Paul

[peet]

Yes, there are tons of people with good skills in here, and they do tend to compete in getting a fast and good solution for those who ask. Never seen any better forums

[A[L]C]

dunno what laguages u know, but if you want something to do (lol) then heres a personsal request


http://www.vbforums.com/showthread.p...hreadid=101430


paul