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:
Thanks for any help in advance.
Bookmarks