how to loop through all sheets in workbook

[narsing18]

Hi
i am trying to make this code work through all sheets, this code should check all sheets in work book and delete "abcd", "xyz" values in all sheets.

Please Login or Register  to view this content.

please help ,if possible i should be able to skip specific sheet.

[cytop]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Sintek]

Give this a go:

Please Login or Register  to view this content.

[cytop]

Please Login or Register  to view this content.

The 'Case Else' and label 'zz' are not needed...

[narsing18]

Hi
Its throwing compiler error : expected array

Thanks

[jindon]

I just don't agree with

Please Login or Register  to view this content.

It might slow the process.

[jindon]

Try this

Please Login or Register  to view this content.

[narsing18]

@jindon ...thanks its working perfectly ...as i mentioned in my first post can i skip any particular sheet if possible.

[jindon]

Just add another Select Case statement like

Please Login or Register  to view this content.

[narsing18]

Hi Jindon,

this is working but there is some problem with this code....if i high lite sheet1 and run the code it skips that sheet and delete the specific rows from all the sheets ,

but if am high lite any other sheet like sheet3 and run the code its skips the sheet1 and skipping the other sheet like sheet4 and its happening randomly.

can you please check below is the code i applied.

Please Login or Register  to view this content.

[jindon]

Missed....

Please Login or Register  to view this content.

[narsing18]

its did the trick.....working perfectly....: