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
Seamus2626Asked:
Who is Participating?
 
Haris DulicConnect With a Mentor Commented:
Hi,

issue here is the space in the file name of the excel file from where you are reading the value.

Corrected formula is : .Range("AO2").Formula = "='[Controls FI.xlsm]Control_Sheet'!$K$5"

Notice the
'
 which i added...
0
 
Seamus2626Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.