Advice on VBA code run time error

[VBA learner ITG]

Hi all,

I was wondering if someone could explain the reason why VBA doesnt like the formula.

And I am getting this error message?

Run time 483 object doesnt suport this property method.

'COLUMN N
        LastRow = .Range("A" & .Rows.Count).End(xlUp).Row
        .Range("N4:N" & LastRow).FORMULA "=IF(E4="Y",$E$3,"""")"
        'Convert to values
        .Range("N4:N" & LastRow).Value = _
                   .Range("N4:N" & LastRow).Value

 

[Fluff]

You are missing an = sign & you also need to double-up all quotes inside the formula

.Range("N4:N" & LastRow).FORMULA = "=IF(E4=""Y"",$E$3,"""")"

 

[VBA learner ITG]

You are missing an = sign & you also need to double-up all quotes inside the formula

.Range("N4:N" & LastRow).FORMULA = "=IF(E4=""Y"",$E$3,"""")"

Thank you for your time Fluff, I thought I copied it correctly from the above code but I must have made a mistake.

 

[Fluff]

You're welcome & thanks for the feedback.