Reference Table Index number

[Av8tordude]

I'm trying to reference a table in my worksheet (which works fine by name), however, since I will be duplicating the sheet, the table name will change. I tried to reference the table by index number , but it fails. how do I reference my table by index number. The table index number is 2

With OHLCChart.Chart
    .SetSourceData Source:=Range("tblChartData3")
...
...
End With

to

With OHLCChart.Chart
    .SetSourceData Source:=ActiveSheet.ListObjects(2)
...
...
End with

 

[Av8tordude]

Anyone?

 

[JoeMo]

Try:

With OHLCChart.Chart
    .SetSourceData Source:=ActiveSheet.ListObjects(2).DataBodyRange
...
...
End With

EDIT: If you want to include the table header row in your SourceData, replace .DataBodyRange with .Range

 

[Av8tordude]

That fixed it. Thank you Joe for your help.

 

[JoeMo]

That fixed it. Thank you Joe for your help.

You are welcome - thanks for the reply.