Hi there

I need a code to update the axis label range to something like this.
='Sheet'!F9:BG9

I am also using vba to create 2 addresses in 2 cells

cell D55 will show F9
cell E55 will show BG9

the value in D55 & E55 can change, and must then update the axis label range accordingly