Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

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
0
Frank Freese
Asked:
Frank Freese
1 Solution
 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now