Really Weird Non Reproduceable Bug !!

[superlative]

In my workbook, I have mastered the drag and drop. There are different drag and drops in Excel, there is the "shift drag and drop", the "ctrl drag and drop" and the default drag and drop. They either do a shift and insert, or a shift and overwrite.

By mastering it, I mean I can detect which one the user is doing and force a shift and insert.

After a month of coding other areas, I was shocked to learn that my drag and drop now overwrites the row above if the row above is a "heading" type row. I searched through hundreds of lines of code to try and remember what code I must have changed to do that, as I did not touch that area of code for months (since it was working fine). No luck.

Eventually I dug up an old version that did not have the bug, and began copying over code bit by bit from a newer version, hoping to find out which bit of code would do it. I got to the stage where ALL code is copied over to the old version, all forms are copied over, all new worksheets are copied over - as far as I can tell, the older version has the same functionality as the new version and YET the old version does not reproduce the bug.

I don't want to show the code, as it is thousands of lines, and I myself can't find the culprit, but wanted to write here to see if anyone has ever had this problem where they could not find the bug even after copying over everything from a new version to an old version that didn't have the bug. I can't figure it out.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)