What has happened to my VB editor all of a sudden??
When I try to dimension rCel as variable Range intelisense comes up with Range as soon as I type R (as per normal), I press enter.
Later in the code I type rCel.O and intelisense comes up with Offset (as it always has), I enter the offset values.
Now when I run the code Offset is highlighted and I get error message saying sub or function not defined.
I rebooted hoping that would clear the error but not to be.
I now find that the same error is in all macros in all workbooks.
All was fine 15 minutes ago!!!
I have not changed any settings.