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?