I want to create a variable based on the number of Y's in a column

[Jubb]

I have a column in a list of data that I've labeled each line with Y or N. I want to make a variable equal the number of Y's in that column. Once again, I'm very new to VBA and I'm using you all and a book that I'm going to replace very soon to learn as references to learn as much as I can. So far, this is what I've got. FYI - FinalRow works just fine as it's used in other parts of the macro.

Please Login or Register  to view this content.

Thanks for any help you can offer.

[Norie]

Try this, which assumes FinalRow is defined elsewhere in your code.

Please Login or Register  to view this content.

PS Can you edit your post to add code tags?

There's a link in my signature that explains how to.

[Jubb]

That's better, thank you. And, thanks for the help with the code tags.

[Norie]

Jubb

Is the problem solved?

It is then you can select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.