Explain Syntax Error

Hi Pike
Thanks for the reply

The above is the part is passed to .subject variable in my function called SendEmail which send email when a cell value is changed. So overall the SendEmail function is working fine.
I'm using Ron DeBruin method of sending email

So when i'm selecting a Yes in the attached spreadsheet, the right strcode value is not getting inserted to the subject

Thanks for the reply Pike

Is there any functionality in excel that i could use to make sure that if there are 3 Yes in the row and someone changes the G8 to No and then change G8 back to Yes, strcode will pull the value relevent to G8 only and not break the code

Thanks Pike

I figured out solution. I had to make the condition to execute a bit more strong to resolve this issue

The following were the changes. Those higlighted text in red were the ones i have omitted
Although the logic still doesn;t pick up correct strcode if certain rows are already set to Yes.
But this is better than before

Please Login or Register  to view this content.

Originally Posted by pike

good stuff what were the changes?