out of range after new user profile

M

Michael

after a new user profile was given the following function gives RT-error
"index out of range"

Private Function sheetexist(shn As String) As Boolean
On Error Resume Next
sheetexist = Worksheets(shn).Name = shn
End Function

Annoying, although easy to reprogram.
No idea where to look for solution
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top