VBA learner ITG
Active Member
- Joined
- Apr 18, 2017
- Messages
- 267
- Office Version
- 365
- Platform
- Windows
- MacOS
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.
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.
VBA Code:
'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