Run-time error 9

I have attached the workbook where every time I try to copy a worksheet to a new book I get:
"Run-time error 9
Subscript out of range"
in the lstCatergory_Click sub routine (on the "Menu" tab) at:

Sheets ("Menu").lblDescription.Caption=" "

I'm lost at resolving this problem.
Frank FreeseAsked:
Who is Participating?
Rgonzo1971Connect With a Mentor Commented:

lblDescription.Caption is not a property of Sheet
Sheet names are not allowed to be blank as well.

Frank FreeseAuthor Commented:
thank you
now I have to figure a fix for this
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.