-
May 24th, 2012, 02:43 PM
#1
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
End If
End If
End Sub
It is located in Sheet 2's- worksheet- change environment.
-
May 24th, 2012, 03:50 PM
#2
Re: Private Sub Worksheet_Change not effecting worksheet
I am receiving a Run-time error '424' Object required
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|