tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Two simple macros
why does Macro2 work but not macro3,
is it not possible to do what i trying to do in one line? or have i got it wrong?
Please help
thanks
Tony
Two simple macros
why does Macro2 work but not macro3,
is it not possible to do what i trying to do in one line? or have i got it wrong?
Please help
thanks
Tony
VBA Code:
Sub Macro2()
ActiveSheet.ChartObjects("Chart 5").Activate
ActiveChart.FullSeriesCollection(1).Format.Fill.ForeColor.RGB = RGB(198, 224, 180)
End Sub
Sub Macro3()
ActiveSheet.ChartObjects("Chart 5").FullSeriesCollection(1).Format.Fill.ForeColor.RGB = RGB(198, 24, 180)
End Sub