-
The easiest way is to do something like this: Rows("62:64").Select Selection.Insert Shift:=xlDown This would insert three rows below the subtotal at row 61. It will move any data in rows 62 through 64 down. Pgmer
-
Hi Anonymous! This is how I would add a new worksheet and attach the "Calulate" event handler (the example shows a message box each time the calculate event is triggered): Private Sub NewSheet_Click() Dim oXl As Application: Set oXl = Application oXl.EnableEvents = False oXl.DisplayAlerts ...