Hi.
This is weird. I have a macro that I recorded from the keyboard and mouse.
Basically the macro is activated by a button and pastes a single column of text into F:F of sheet one, copies it to A:A of sheet two where four blank lines are inserted between each cell and then copies the column back to column G:G of sheet one.
When I step through (F8) it works perfectly, however using the button causes the macro to miss the first two of the four line insertions. This then puts the cells in the wrong place when the column is pasted into it's final position in sheet one.
Has anyone seen this sort of behaviour before?
And any ideas what's going wrong? I'm using Excel 2007.
Here's the code:
Thanks
Steve.
Bookmarks