May 24th, 2012, 03:43 PM
Private Sub Worksheet_Change not effecting worksheet
I am trying to get the y-axis to divided by 1000 is c2 has the words Million Barrels per Day. I am not understanding the chart is not changing. Below is my wording. Any help is greatly appreciated!
This is my script:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$c$2" Then
If ActiveCell.Text = "Million Barrels per Day" Then
ActiveSheet.ChartObjects(2).Chart.Axes(xlValue).DisplayUnit = xlThousands
It is located in Sheet 2's- worksheet- change environment.
May 24th, 2012, 04:50 PM
Re: Private Sub Worksheet_Change not effecting worksheet
I am receiving a Run-time error '424' Object required
Click Here to Expand Forum to Full Width