Seamus2626
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
.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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER