One of my users has a legacy Excel 4.0 macro that moves content between sheets. It has worked properly in Excel 2010, but my company is transitioning to Office 2013/365, and it malfunctions in 2013 (both of which I've verified). I'll admit I'm a bit of a novice at 4.0 macro code, and it's a lot harder to troubleshoot than VBA code. The macro is normally triggered from a shape button on the source sheet. I found that it works properly in Excel 2013 when I run it from the Macros window, a custom macro button on the QAT, or a custom button added to the ribbon. That leads me to believe it's some kind of a problem with the focus getting changed by clicking the button, and that throws off the rest of the steps that expect a specific cell to be active.
I don't have permission to post the entire file, but here's the line where things start getting wonky:
2014-11-04_16-52-57.png
Before I dig in and start rewriting the whole thing in VBA, does anyone know whether there's a known issue with this around Excel 2013? Thanks!
Bookmarks