LinkBack URL
About LinkBacks
I'm getting a Runtime Error of an invalid parameter for this line ofThat line of code is in this sub
Please Login or Register to view this content.So how do I fix the parameter?Please Login or Register to view this content.
I'm getting a Runtime Error of an invalid parameter for this line ofThat line of code is in this subPlease Login or Register to view this content.So how do I fix the parameter?Please Login or Register to view this content.
Does the activechart have enough series for you to use series collection 2?
When taking a look at the chart I believe that the chart only requires one series. Would I be able to email you the file, so you could take a look at it for me?
Well if the chart only has 1 series trying to select the 2nd or 3rd will cause an error.
You should really check the SeriesCollection.Count property before do the code relating to series.
When getting more information about the workbook, I realized that their were more charts that were suppose to show and not one. I'm going to email you the file so you can try to help me with my problem.
As I said you need to test for valid series before trying to format it.
BTW chart sheets can not contain textboxes from the control toolbox.Please Login or Register to view this content.
You need to add shapes and add text to them
Okay thanks. And if you look look in Module 1 of that file the line ofSometimes give off an error which says that 'Run-time error '1004':Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook referenced by Visual Basic. ' Is it because when I run the macros of code it keeps on making up the same sheet with the same name? I deeply appreciate your help.Please Login or Register to view this content.
The problem I'm having is that my program works completely fine in Excel 2003, but for Excel 2007 it shows errors. Why is this you think?
This error has nothing to do with versions it to do with trying to name sheets with names that already exist.
First time your workbook opens the sheets are all created.
Second time it just does the same thing again only the sheet already exists.
Add this routine and code to stop creation if already present.
Please Login or Register to view this content.Please Login or Register to view this content.
Thanks man. You are the best.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks