Looping through select worksheets

[MatchaLatte]

Hi VBA gurus,

I'm trying to get my vba to add in a date to certain worksheets in my workbook. The date has to be added to the last blank row on columns A and S. This is the code i have so far but it applies to all worksheets in the workbook..

How do I get it to exclude certain worksheets by name like "Sheet 1" and "Sheet 3"?

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

Your existing code does not apply to all worksheets. It never references a worksheet. Maybe you mean to do this:

Please Login or Register  to view this content.

I just addressed the issue of the worksheet and not the rest of your code. You may have other problems. For example, you are populating cells with a string, not a date. The way you are getting the last cell in the column may work but seems a bit overcomplicated.

[AlphaFrog]

Please Login or Register  to view this content.

[MatchaLatte]

Thank you so much for your help, Jeff! Noted on the other problems! Still a newb at VBA so my codes are still v clunky!

And thanks AlphaFrog for cleaning up the rest of my code - everything worked :D

[MatchaLatte]

Hi Everyone, how do I get the if statement to exclude multiple sheets and not just two?

[6StringJazzer]

Just keep adding more choices into the If condition, using And for each one.

Do you have a naming convention for your sheets that we could take advantage of?

[MatchaLatte]

I tried adding "And" for each one but it gives me an error..

Let's just say the sheets I'm looking to exclude are called "Small", "Mid","Large","Extra Large" so they have unique names

[jolivanes]

Or like this. Less cumbersome by the looks of it

Please Login or Register  to view this content.

Saw your last Post too late. Change the names in the exclude line to suit your need.

[MatchaLatte]

Thanks! But I really want to keep the original code using the if and then statements since it allows me to plug in the date just once

[6StringJazzer]

To use the date, modify as shown:

Please Login or Register  to view this content.

[MatchaLatte]

Thanks so much 6StringJazzer!! That worked perfectly