Using cell value to set range for chart

[jrembold]

After recording a macro where I manually changed the data range here is what I got.

Please Login or Register  to view this content.

I made formulas so that the starting and ending cells are always located in "D1" "D2" and "D3". After trying to change it so that the code can be looped and used in multiple sheets here is what I tried.

Please Login or Register  to view this content.

I can't seem to find a way to use the value from set cells to create the new data range for a chart of the same sheet. Thanks allTest Sheet (Updated Jonathan's Version 6.19.15).xlsm

[yay_excel]

I don't think you can use ActiveSheet in a string. Try ActiveSheet.Name instead. Your range parameter will be like:

Please Login or Register  to view this content.