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.

Sub Updatedata() 
    Dim Follow_up_column As String 
     
     
    Follow_up_column = Sheet3.Range("Q" And Row_number) 
     
     
    If Follow_up_column = "Yes" Then Follow_up_column = "Reminder Sent" 
End Sub