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>
To: ExcelVBA@yahoogroups.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]
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