Guys,

I am still trying to make a chart with a macro but the data range
changes within one column.

What I have is column B with values but they start and end differently
each time.

Now I am thinking I could use one of the functions that detects the
first and last used cell and write that cell into a different cell.

Then I just need to make a chart from the start and end thaat is in
lets say AA1 and AA2.

BUT I dont know how I can reference that the chart is built from the
start and end cell that is in a different cell..

Any help appreciated. Programming isnt my thing (as you may have
noticed)

Matt