Run-time error 9

Folks,
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.
Charting-Data-in-Excel-2010.xlsm
Frank FreeseAsked:
Who is Participating?
 
Rgonzo1971Commented:
HI,

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

Regards
0
 
Frank FreeseAuthor Commented:
thank you
now I have to figure a fix for this
0
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.