Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

Application defined or object defined error

I have some VBA Formula -  

.Range("AO2").Formula = "=[Controls FI.xlsm]Control_Sheet!$K$5"

It picks up a date from K5 the file Controls FI

I am getting "Application defined or object defined error" when it attempts to step through the above line

Can anyone suggest why this is?

Many thanks
ASKER CERTIFIED SOLUTION
Avatar of Haris Dulic
Haris Dulic
Flag of Austria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Seamus2626

ASKER

Thanks!