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
Macro not working correctly
-
- 3StarLounger
- Posts: 307
- Joined: 16 Mar 2011, 09:33
Macro not working correctly
You do not have the required permissions to view the files attached to this post.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Macro not working correctly
The workbook is password protected and cannot be opened.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 307
- Joined: 16 Mar 2011, 09:33
Re: Macro not working correctly
Apologies Password is Secret
-
- BronzeLounger
- Posts: 1499
- Joined: 28 Feb 2015, 13:11
- Location: Hof, Bayern, Germany
Re: Macro not working correctly
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:
If you run the macro with the extra space there,
Case "With Spout "
then it works
Alan
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:
If you run the macro with the extra space there,
Case "With Spout "
Code: Select all
Case "With Spout "
Alan
You do not have the required permissions to view the files attached to this post.
I am having difficulty logging in with this account just now.
You can find me at DocAElstein also
You can find me at DocAElstein also
-
- 3StarLounger
- Posts: 307
- Joined: 16 Mar 2011, 09:33
Re: Macro not working correctly
Thanks Rudy and Alan