David
What keeps you from breaking this into multiple workbooks to get around problem?
I was thinking that if it were smooth "presentation" of the data,
Using a "pile" of workbooks could be (at least partially) hidden by using hyperlinks to instrument the navigation.
Db
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf Of David Lanman
Sent: Sunday, September 11, 2011 10:39 AM
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] Re: Error and shutdown
Thanks David. Charting and trying to do it with VBA is not very good. The order you do it in makes a difference and almost anything you do to the worksheet seems to make a difference.
With ActiveChart.Parent
.Placement = xlFreeFloating
End With
The above seems to help some, but does not seem to "stay in place."
Selection.TickLabels.AutoScaleFont = True
Will void the previous VBA and seems to be the norm when you record a macro. MSN help documentation is pretty poor too.
David
From: david braithwaite <dbraithwaite@charter.net <mailto:dbraithwaite%40charter.net> >
To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
Sent: Saturday, September 10, 2011 7:48 PM
Subject: Re: [ExcelVBA] Re: Error and shutdown
Hi david
It appears that there is a maximum of 512 font types in an excel workbook.
Microsoft posted this
http://support.microsoft.com/kb/215573
The article indicates that the number often grows out of control due to
auto-sizing ---
I have found that if you google the error message you often come up with
something useful.
Do this and you will find that other people have been where you are.
Db
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar