Hello,
I'm trying to create a macro that will copy and paste values from several workbooks into one sheet and create a chart. With the command button, I would like it always to use just the range and loop through the workbook's sheets. However, when trying to use the code I get an runtime error of 91 which says, "With block variable or object variable not set". The only way I could think of solving this would be to add the chart_magic macro into the command button, but that seems kind of ugly. There's got to be a better way.
Bookmarks