Solved

Run-time error 9

Posted on 2014-03-24
2
242 Views
Last Modified: 2014-03-24
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
Comment
Question by:Frank Freese
2 Comments
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39950412
HI,

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

Regards
0
 

Author Closing Comment

by:Frank Freese
ID: 39950453
thank you
now I have to figure a fix for this
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now