Begins with
 

Try this:

If ActiveCell.Value Like "C1*" Then ActiveCell.Offset(0, -1) =
ActiveCell.Value & "Primary"


StephanieH wrote:
Can anyone tell me how to correct his line?
If ActiveCell.Value = "C1*" Then ActiveCell.Offset(0, -1) = "Primary"

I'm basically trying to evaluate if the value in the cell begins with C1
then write the word "Primary" in the cell next to it.

When I hover over ActiveCell.Value, it give me C1ARM so I know it's seeing
it correctly, I guess just not recognizing the C1* part?

Begins with
 

Oops. I meant
If ActiveCell.Value Like "C1*" Then ActiveCell.Value =
ActiveCell.Value & "Primary"


wrote:
Try this:

If ActiveCell.Value Like "C1*" Then ActiveCell.Offset(0, -1) =
ActiveCell.Value & "Primary"


StephanieH wrote:
Can anyone tell me how to correct his line?
If ActiveCell.Value = "C1*" Then ActiveCell.Offset(0, -1) = "Primary"

I'm basically trying to evaluate if the value in the cell begins with C1
then write the word "Primary" in the cell next to it.

When I hover over ActiveCell.Value, it give me C1ARM so I know it's seeing
it correctly, I guess just not recognizing the C1* part?