Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi. I defined a macro that will copy the current row and do a copy
insert. It looks like this: Sub CopyInsert() ActiveCell.EntireRow.Select Selection.Copy Selection.Insert Shift:=xlDown Application.CutCopyMode = False End Sub This works well. The problem is that after I run the macro, I can't undo the changes. It seems to clear the undo buffer. Is there some code I can include in the macro to enable the command to be undone after it is run? Thanks! Ken |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
use macro and allow undo | New Users to Excel | |||
Undo a Macro | Excel Discussion (Misc queries) | |||
Undo row insert from macro | Excel Programming | |||
UNDO in EXCEL97 macro | Excel Programming | |||
Undo Macro | Excel Programming |