copy / insert issue
Hello Excel User Voice,
I have a macro that worked fine for over a year, but after the latest Office update something changed and the macro behaves differently.
Initially, I thought that it was the Insert method that changed, however, having tested this now i can see that it's the Range.Unmerge method that behaves differently.
We have users with three different Office builds in the team:
For users on build 1 and 2, Range.Unmerge method unmerges the cells AND clears contents of clipboard AND/OR sets the Application.CutCopyMode to False.
For users on build 3 the same method only does the unmerging part.
I created a test version of the macro and recorded it with Steps Recorder on two different machines (see the attached files).
Recording 1 is an older build (16.0.4498.1000 64-bit). It just happens to be a 64-bit version, but the behaviour is identical on 16.0.7329.1054 32-bit.
Recording 2 is a machine with the latest Office update installed - 16.0.8201.2075 32-bit.
As you can see in Step 9 of Recording 1, the clipboard gets cleared on Range.Unmerge hence Range.Insert just inserts empty rows (step 11).
And on Recording 2, on step 9, you can see the paste options are not greyed out as the range is still in clipboard, hence the result of Range.Insert is different.
Why has this changed?