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?