Compile error Wrong number of arguments or invalid property assignment

[Giordano Bruno]

I have recently found that a number of macros which used to work are now failing with the above message. It happens on my desktop computer, but not on my Surface Pro. The simplest test is to open a workbook, set the cursor in the top left corner and start to record a macro. I hold the shift key and press the down arrow and then stop recording. The recorded code is "Range("A1:A2").Select" Not brilliant code, but it works on my Surface Pro. When I try to run this code on my Desk top computer I get the Compile error message. It can be fixed by typing "ActiveSheet." before the word "Range". Neither the error message, not the Help option seem to refer to the situation. Can anyone tell me why this problem occurs on my desktop computer and what can be done to fix this issue?

 

[Giordano Bruno]

Hi Alex. I just had Solver running and it doesn't help to remove that. Thanks for the idea.

 

[RoryA]

Have you run a repair of Office on the problem machine?

 

[Giordano Bruno]

Hi Rory, Thanks for the suggestion. Yes, I've run both the slow version and the fast version and also reinstalled office 365.