I have prior Macro recording and VBA experience in Excel. After I install and active Office 365 ProPlus on my new machine (ThinkPad E480), the Macro recording generate wrong VBA Code. There are not additional add-in installed on this Office, with all default setting.
To Replicate This Error (only in my machine)
1. Start Macro Recording
2, Click on Cell B4
3, The Code generated is Range("B4").ErrorString instead of Range("B4").Select
Done Online Repair and the problem still persist.
All using default setting in Office.
Appreciate your advise on how to rectify this. Thanks!
Hi! I also experience the same thing. Instead of copy, paste, etc, my "record macro" produces vba that says "delete". I don't see the feedback button in my excel 2016. What can I do to correct it? Thank you!