Use offset with cell value as column reference

[antho27]

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!

[AB33]

Yes, so long as the cell is long variable(Number).

[antho27]

what would the code be, I tried to reference the cell, lets say (A1) but nothing happened.

[AB33]

Like this

Please Login or Register  to view this content.

[antho27]

Thank you!!

Perfect.