Increment a number based on the text in the adjacent column

Hello,

In column B i will only have 3 values, either S, U or M. I need a counter in Column A that starts at 1 and for each time column B has a U or M increment that number in column A. If Column B contains S, then leave A blank, no counter needed for those. I need to implement this in VBA, not in the worksheet.

Any thoughts?

I. E. This is an example of how it would look.

Col A ColB
----- -----
S
1 M
2 U
S
3 U
4 U
S
5 M


I thought this would be a simple task, however I am finding out that it is not so easy!!

Ron, thanks so much, this is working the way I want, but with a few little corrections to it. However when I put this in VBA to copy to the last row I am getting error about range of object method. Below is the code. I know this may be a different thread, but do you have any ideas?

Please Login or Register  to view this content.

Sometimes when you stare at code all day, ya get a little crosseyed, and that must have been what happend to me here!!

I got this corrected, "" in the wrong place, line that was corrected and correct version below

BAD!!

Please Login or Register  to view this content.

Good

Please Login or Register  to view this content.

Issue resolved, thanks Ron