May 06 2018 12:55 AM - edited May 06 2018 01:02 AM
Hi,
need helps here.
Background
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
Troubleshooting Performed
Done Online Repair and the problem still persist.
All using default setting in Office.
Appreciate your advise on how to rectify this. Thanks!
May 06 2018 09:09 AM
Hi Tai,
It seems to be a bug in the macro recorder as there is no property in the Range object called: ErrorString.
I advise you to report this to Microsoft through Help (Ribbon tab) >> Feedback.
Regards
May 09 2018 10:42 PM
May 10 2018 05:41 AM
Hi Arianne,
There is a ribbon tab called Help!
If you don't find it, right-click the ribbon and select Customize the Ribbon, then find the Help checkbox, and check it.
If you didn't find it, then it's not available in your version of Excel, in this case, you can ask this community which is the best place to get support.
Regards
May 11 2018 03:21 PM
May 11 2018 03:23 PM
it's now resolved via simple method below
1. uninstall Office (don't borthered with online repair)
2. reboot computer
3. install office with new setup file
hope this helps
Jun 21 2018 07:55 AM
Hi Tai,
I'm having the same trouble with my new Thinkpad, and even after reinstalling Office, I'm getting the same errors with Excel macros. Any other suggestions?
Dec 02 2019 10:24 AM - edited Dec 02 2019 10:28 AM
Having a similar problem, that when I try to record a Macro, VBA does not do what I expect. For instance, I select a range, but VBA records it as Range("A5").DataFields. Unexpected and disappointing.
Per this thread, I'm reinstalling Office. Very inconvenient because I use Excel every single day. Will edit/update if reinstalling fixes my problem. EDIT: Reinstalling worked.