Re: I am trying to export multiple charts in multiple excel sheets within same excel file.
It would help if you could indicate which line is triggering the error. My guess is that the new Excel workbook is being created with a single tab, and the problem is occurring when you reference tab 2 (Sheets(2)) or 3. The number of tabs in a workbook is user configurable and it may not be the default of 3.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein