what does Error X400 mean?

[tonywatsonhelp]

Hi Everyone,
Not had this before but everytime i insert a formula into a sheet I get an error pop up say Microsoft visual basic for aplications X 400
any ideas whats cousing it?

Thanks
Tony

 

[Special-K99]

What's the formula you are entering?

 

[tonywatsonhelp]

Just =K27 for example. its stoped now but just wondered why it happened?

 

[Special-K99]

Is it a macro enabled spreadsheet with VBA ?

This perhaps?

https://www.add-ins.com/support/microsoft-visual-basis-error-400.htm