I think I already know the answer to this one, but....
The two lines of code below allow you to "add" or "delete" rows.
If you use the built in tools to "add rows" or "delete rows" it contains an animation of the rows being added or deleted.
If you use a macro code for these tools, the animation is no longer there.
Is there by any chance, a piece of coding that can get these animations into your macro?
As stated above I would imagine those animation are coded within Excel itself, but I thought I would just ask just in case.
Thank You
The two lines of code below allow you to "add" or "delete" rows.
Code:
Selection.EntireRow.Insert
Selection.EntireRow.InsertIf you use the built in tools to "add rows" or "delete rows" it contains an animation of the rows being added or deleted.
If you use a macro code for these tools, the animation is no longer there.
Is there by any chance, a piece of coding that can get these animations into your macro?
As stated above I would imagine those animation are coded within Excel itself, but I thought I would just ask just in case.
Thank You
