Why isn't this code looping through all the sheets?

This code will work on whichever sheet is currently active, but will not continue on to loop through ALL of the sheets. I can't figure out what's wrong. Does something else need to be initialized? Thanks for any suggestions...I'm pulling my hair out!

Please Login or Register  to view this content.

attach file to help the members
try this just suggestion

HTML Code: 

You need to qualify the Sheet object to the range

Please Login or Register  to view this content.

Otherwise, it always refers to ActiveSheet.Range(....)

Originally Posted by KOKOSEK

Sheets.count is more likely for FOR loop. (for i=1 to sheets.count)

I think:

Please Login or Register  to view this content.

as you want to check the same range on all sheets.

with this:

Please Login or Register  to view this content.

My_range is reference into activesheet.

Perfect! My greatest struggle with VBA is understanding initializing and qualifying and when/when not necessary. Thank you so much!!