Insert shift:=xlDown inserts junks on the sheet

Hi,
I have a workbook thats been used by hundreds of customers, for years, which uses the following code:

Rows("2:2").select
selection.Insert shift:=xlDown

On all the machines, office 2007, 2010, 2013, 2016 this code works fine, shifting the second row down, so I have a blank 2nd row now.

But on one customers machine (Office 2016), the selection.insert line, inserts the previously selected range( which happens to be the second column) in all the columns ( to column XFD) and shifts everything else, on this sheet down... and that messes up everything!!!
In this case I only have two columns on this sheet, to start with.

is there a Property in Excel that I can change to fix this issue, without changing the code?? since it seems to be working fine for everyone else except this one customer, as a quick fix? since I am not doing another release till end of the year!!

I hope my explanation makes sense..

thank you,
Karen16

Hi Karen,

The selection may be fouling it up - try:

Please Login or Register  to view this content.

It's not really anything to do with any Excel property.

In the code you use Selection when inserting, and even though you've just selected row 2 that might not be exactly what you think it is.

If you want to insert on a specific row/range/whatever then use an explicit reference to that row/range/whatever, eg Rows(2).

Hi Karen,

You're welcome and thanks for the rep!

Norie answered your question the way I would have liked to

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

They probably "fixed it" thinking it was broke