Loop through all worksheets.

I keep getting a error on the below line. I have been trying to figure this for a while and no longer posses the ability to think out side the box.

The macro looks for cells with "0" in them and deletes the zero.

I get errors on these two lines,

Please Login or Register  to view this content.

Please Login or Register  to view this content.

"0" is text string. The number zero does not have quotes around it.

This is how I would write that:

Please Login or Register  to view this content.

You meant for each WS in worksheets? And you meant numeric 0 not text value 0 right?

Thanks Jerry, that did the trick. I am gathering find is quicker than looping through each cell?

Yes, the FIND method jumps directly to the next cell with the searched value, much more efficient than checking each cell row by row yourself. Eventually there are no more values that match (since you're removing them) and the zFIND range equals nothing. At that point the macro exits.


Note, to implement this method in a macro where the values are NOT being removed as you jump through them all, you'll need to set a secondary range to remember the first one found so that when you come back around to where you started, you'll know and can exit. Here's the same macro again without the delete value command, so you can see what I mean.

Please Login or Register  to view this content.

Thanks Jerry,
That make things a whole lot clearer.