Looping through sheets and creating charts issue

Hello folks,

I have following code which is not behaving the way I want.

Please Login or Register  to view this content.

The problem is the last statement, a chart which gets created in an iteration does not "move" to a new sheet but rather same sheet. So end result is a sheet with chart of the last iteration.

How to get this code to create new charts in new sheet and not the same sheet. A help will be greatly appreciated.

Not really clear from your description what you want.

Why not try recording the code and then replacing the last biit with correct syntax.

You probably want to loop through Worksheets rather than Sheets, as sheets includes chartsheets which will not have ranges on it.

I just tried something and it seems to work fine for me (1 new sheet for each chart) but only after I change ThisWorkbook to ActiveWorkbook.

This was what I did:

Please Login or Register  to view this content.