garethtnash
asked on
Excel VBA - Run Time error '1004' Application-defined or object-defined error
Help!
I'm getting the following error -
When I run the following code -
its the last line that gets highlighted
Thanks
I'm getting the following error -
Run-time error '1004';
Application-defined or object-defined error
When I run the following code -
LR2 = Range("A" & Rows.Count).End(xlUp).Row
Ws.Range("BM1").FormulaR1C1 = "Current TS?"
Ws.Range("BM2:BM" & LR2).FormulaR1C1 = "=IF(AND(RC63 = RC62, RC57 > 0), ""Current"", "")"
its the last line that gets highlighted
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I do not see how Shaun's answer is right
ASKER