Hi guys, a question for you Excel VBA experts. I wrote the following function which applies formatting to a chart:
Function FormatAxes(Optional SheetName As String, Optional ChartName As String, _ Optional IsEmbedded As Boolean, _ Optional Xmin, Optional Xmax, Optional Ymin, Optional Ymax, Optional XMinorUnit, _ Optional XMajorUnit, Optional YMinorUnit, Optional YMajorUnit) Dim xlChart As Chart If SheetName = vbNullString Then SheetName = ActiveSheet.Name If ChartName = vbNullString Then ChartName = ActiveChart.Name If IsEmbedded Then Set xlChart = Worksheets(SheetName).ChartObjects (ChartName).Chart Else Set xlChart = Charts(ChartName) End If .... End Function As you can see, i tried to wrote it in such a way that the code would work also if the sheet name and chart name are not given in input: in that case, the code usese the active sheet and active chart. Then I realized that such a code would work only on embedded charts, so I added the IsEmbedded optional parameter, which tells the code if the chart is embedded or not. However, I'd really prefer the code to determine by itself if the chart is embedded or not, rather than relying on the user to supply the correct value for the IsEmbedded optional parameter. Could you please help me do this? Thank you very much, Best Regards Sergio Rossi ps if anybody is interested in the full code of the function, and/or its goal, feel free to ask :)
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe