VBA to cycle through worksheets

Please Login or Register  to view this content.

I am trying to delete blank rows in selected worksheets; however, the above code only allows me to select the active worksheet (Only one). How can I manipulate the code that will allow me to cycle through all of the worksheets, not just one. I could have up to 15 different worksheets, sometimes 8. I want it to cycle through all of them and delete all blank rows.

.

Please Login or Register  to view this content.

Hello A1cswiz,

You could try something a little simpler as follows if it suits you:-

Please Login or Register  to view this content.

This code assumes that entire rows are blank in each worksheet.

I hope that this helps.

Cheerio,
vcoolio.

@Logit:-

Geez you're quick!

Cheerio,
vcoolio.

Try

Please Login or Register  to view this content.

Originally Posted by vcoolio

@Logit:-

Geez you're quick!

Cheerio,
vcoolio.

Too funny !

That works perfectly, thanks for the reply

.
You are welcome.

Hello A1cswiz,

I'm not sure to whom you are referring but you're welcome anyway.

Cheerio,
vcoolio.

Originally Posted by vcoolio

Hello A1cswiz,

I'm not sure to whom you are referring but you're welcome anyway.

Cheerio,
vcoolio.

I’m referring to everyone in the whole thread, especially you man, thanks