Macro not working correctly

[vilas desai]

Dear Experts

The attached file has a worksheet Est_wt with a macro on Cells C16 and c17

While the macro on C16 works, it does not on C17

Can i get a help please

Regards
Vilas Desai

[Rudi]

The workbook is password protected and cannot be opened.

[vilas desai]

Apologies Password is Secret

[Doc.AElstein]

You have a typo in the spelling of
With Spout
In your drop down list

It has an extra space at the end - you have "With Spout "
If you select that option from the drop down list, then click in the formula bar , you will notice the extra space on the end:

With Spout Extra Space.JPG

If you run the macro with the extra space there,
Case "With Spout "

Code: Select all

                Case "With Spout "

then it works

With Spout and Extra Space.JPG

Alan

[vilas desai]

Thanks Rudy and Alan