Hey VBA FTW,
When a book is just opened, nothing is selected - if you want to copy the sheet that opens, you could write:
and you could write:![]()
Cells.Copy
instead of:![]()
Rows("4:4").Insert Shift:=xlDown
instead of:![]()
Rows("4:4").Select Selection.Insert Shift:=xlDown
![]()
Selection.Copy
Bookmarks