I am trying to add a line of code in VBA that will ask if the range has a value of HP-1 to then to make it 16 GA. else, it needs to be 26 GA. Currently code just converts everything to 26 GA.

If Sheets "TRIM".Visible Then
     Sheets("TRIM").Select
     Range("D13").Select
     Do Until ActiveCell.Offset(0, -1).Value =""
           If ActiveCell.Value <>""Then
                ActiveCell.Value ="26 GA."
            End If
            ActiveCell.Offset(1, 0).Select
        Loop End If

So I need to add in something that will do the HP-1 condition...I did try to make an Else statement but getting NO compile errors but getting this one.

compile_error_01.jpg

(this error has nothing to do with 32bit/64 bit as we are all still using 32bit Excel with 32bit VBA code)
I'm sure it is pretty easy but can't seem to get the syntax down...
Any suggestions?