Macro Debugging - Charts

[Jfrusty]

Trying to get a set of data to graph via macro. New to debugging a macro as this is the second one I've done. After a few attempts and forum surfing I haven't found a solution that works. Used record to start and this is the line item it generated that has an issue:

 

[rlv01]

Welcome to Mr. Excel. See this link for how to post your VBA code:

How to Post Your VBA Code

Post your VBA code.

www.mrexcel.com

 

[Jfrusty]

ActiveChart.SetSourceData Source:=Range(
        "'Average Days To Sell-30101-Mont'!$A$1:$A$66,'Average Days To Sell-30101-Mont'!$C$1:$C$66,'Average Days To Sell-30101-Mont'!$D$1:$D$66" _
        )

 

[rlv01]

Is your data range valid? Can you run this code without getting a 'chart range invalid' message? Are you getting other error messages?

Sub ChartRangeTest()
    Dim ChartSourceRange As Range

    On Error Resume Next
    Set ChartSourceRange = Range("'Average Days To Sell-30101-Mont'!$A$1:$A$66,'Average Days To Sell-30101-Mont'!$C$1:$C$66,'Average Days To Sell-30101-Mont'!$D$1:$D$66")
    On Error GoTo 0
    
    If ChartSourceRange Is Nothing Then
        MsgBox "The source range for this chart is not valid", vbOKOnly Or vbExclamation, "Worksheet: " & ActiveSheet.Name
    Else
    ActiveChart.SetSourceData Source:=ChartSourceRange
    End If
End Sub

 

[Jfrusty]

Error code is

runtime error 1004 : Method range of object - 'Global' failed

 

[rlv01]

What happened when you ran the code I posted?