Hi,

I have a excel file with lots of individual sheets where I am trying to create a Chart.

I am trying to automate the process in VBA as there is many files each with 10 sheets that need a chart making

I have used the macro recorder to make the VBA, but as the data location is Variable on each sheet I'm having difficulty getting it to select the correct data:

The data I need always starts at A6:B6 but the end is variable could be A53:B53 or A80:B80 etc.

I have attached a copy of the file I'm using initially here: Full Bore Live 2a.xls

The code that I need help with is this bit I think:

Please Login or Register  to view this content.
Thanks for any help in advance.