Delete all charts and empty rows from all sheets; won't change sheets

Hello,

I am working on a macro that would:

1. delete all charts from the sheet
2. select rows from row 1 to last row that has data; this range will have some full and some empty rows
3. delete empty rows from this range
4. move onto the next Sheet and repeat
5. do this for all sheets in a Workbook

My Macro seems to be working more or less fine EXCEPT it would not do the "select rows, delete empty ones" on other sheets but the first one (one in focus). Any ideas what might be wrong?

Thanks!

Please Login or Register  to view this content.

b

Try changing

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Hey Alf,

thanks for your imput, much appreciated! Unfortunately - no. The charts get deleted from all sheets but rows still get deleted only on the first (actually active sheet). I tried chahging

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

but nope. It just wont work

SOLVED!!! My god... after 2 days


'FINAL - deletes all charts AND deletes empty rows from ALL sheets in workbook

Please Login or Register  to view this content.

You solved it!! Good!!!

Don't forget to mark your thread "Solved"

Alf

Ps

To mark your thread solved do the following:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved