"Select Case" not working

[jerseyguy1996]

I have a worksheet filled with bond data. Two of the columns contain the maturity date and market value respectively of each bond. I want to group the maturities of the bonds by year. I wrote a macro that evaluates the maturity date in the first column and sums the value next to it, cycling through the selection until it gets to the end. When I run it, the correct case is evaluating to "True" but it is still skipping over the expression directly under the case statement. Why is the programming not performing the action under the case that evaluates to true? I have attached my code and a sample worksheet below.

Please Login or Register  to view this content.

[Leith Ross]

Hello jerseyguy1996,

You syntax is wrong. What is it you want to test for?

[jerseyguy1996]

Hello jerseyguy1996,

You syntax is wrong. What is it you want to test for?

Actually I just figured it out. I needed to have my statement read:

Please Login or Register  to view this content.

so the program goes:

Please Login or Register  to view this content.