For loop through specific Worksheets

[mason0567]

I need to create a for loop to cycle through Worksheets 2-6 to run an if statement on each individual one and take action on that specific sheet matches those conditions. This is what I have currently:

Please Login or Register  to view this content.

[Norie]

That code looks fine, is there a problem with it?

[mason0567]

When running it, I get the error "Compile error: Sub or Function not defined". Also, it highlights the word 'Sheet' in the if statement.

[Norie]

Oops, didn't spot that.

Sheet should be Sheets.

[mason0567]

Hahaha, wow.... Can't believe I missed that.... Thanks for the help, works just fine