Help with a loop through all sheets

**jnh0** · 08-13-2013, 01:13 AM

MorningReport.xls

Hello guys,

I have this macro, which I need to run in through all sheets but I haven't find the way. Could you help me? thanks!!

Please Login or Register  to view this content.

**patel45** · 08-13-2013, 02:20 AM

attach please a sample file for testing

**jnh0** · 08-13-2013, 02:27 AM

Done you can find it at the top of my previous post! Thanks!!

**jnh0** · 08-13-2013, 02:52 AM

Done guys, I found the way how to do it!

Please Login or Register  to view this content.

**abousetta** · 08-13-2013, 02:58 AM

This might need some tweaking (untested) but the concept should work:

Please Login or Register  to view this content.

abousetta

**abousetta** · 08-13-2013, 02:59 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**jnh0** · 08-13-2013, 03:35 AM

From the same macro, lets say that sometimes the macro don't find the "Resp. Co" if it doesnt find it I want it to delete the sheet

Please Login or Register  to view this content.

I tried with:

Please Login or Register  to view this content.

which is:

Please Login or Register  to view this content.

What Im doing wrong??

Re: Help with a loop through all sheets