Thank You, this works fine.
This was not supposed to be a long time backup, as I know I can't do this way. This was actualy a part of trying to make a workaround for the Undo stack beeing wiped out when I execute some VBA code to update cell formatting.
I now experienced somthing new. This first code, which I made with help from you actually does not flush the Undo stack:
But this code gives med the same result, but flushes the Undu stack:
Both codes makes a copy of the Values in "rngInput" in Sheet1 and put these values in the same cells in Sheet3. The Sub is run from a Worksheet_Change sub in the Sheet1 Code.
Both subs make changes to cells in the Workbook, but the first one does not flush the Undo stack. Do you know why ? I tought all changes to cells in the Workbook with VBA would flush the Undo stack.
Bookmarks