Issue with basic VBA code If command

Hi I'm brand new to VBA and I'm having a little trouble with a fairly basic code which is suppose to select a column in a specific worksheet in my database and replace every row that has "Yes" with "Reminder Sent". This I plan to run together with the macro I set up which automatically sends emails to contacts in my database, I was hoping I could just copy/paste the new "Sub" to the bottom of my email macro code.

Here's the code I've been attempting, It returns a type mismatch error. I've tried doing research on youtube and google but nothing is bringing me success so If anyone has a clue of what could be the issue I'd really appreciate it.

Please Login or Register  to view this content.

Thank you all very much for your help, I've figured out where I've made an issue and have solved it.