Unanswered: macros: adding a chart to sheets with predefined names?
Im pretty new to using macros but have some VB experience, but it was quite a while ago and it was just high school CS. Basically I recorded a macro, and want to apply it to other files as well. Its lab data, there is 1 sheet per file and the sheet is named with the file name, in the below case 'axc160'. How can I make this macro run on a sheet with whatever name? Thanks.