Hello everyone,
Here is a code snippet from the Excel macro book I am reading:
The code runs as expected. I am using Excel 2007. However, when I look through the documentation, I cannot see the Fill method amongst the members of the ChartArea object. I am now wondering if I have an incomplete documentation in my computer. The members of the ChartArea object available in the documentation in my computer are shown below:'Create a gradient pattern in the chart area, changing from red at the top to violet at the bottom With ActiveChart.ChartArea.Fill .Visible = True .ForeColor.SchemeColor = 3 .BackColor.SchemeColor = 7 .TwoColorGradient Style:=msoGradientHorizontal, Variant:=1 End With
ChartArea Object Members.jpg
If it is the case that I have an incomplete documentation, please recommend where to get the full documentation.
Thanks.