Use offset with cell value as column reference

Is there a way to have a cell value be used as the column reference.

Example:
Worksheets("WD6G2").ChartObjects("Chart 1").chart.SetSourceData Source:=Range("B17:B19,AH17:AT19").Offset(0, 1)

I want the 1 to be referenced to a cell in my worksheet so I can update it to the range I need.


Anything is greatly appreciated.

Thanks!