Delete or insert rows in a workbook
Solved/Closed
ehsan
-
Updated on Oct 12, 2017 at 05:46 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 12, 2017 at 11:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 12, 2017 at 11:05 AM
Related:
- Delete or insert rows in a workbook
- How to insert a checkmark in word - Guide
- How to delete a row in a table in word - Guide
- How to insert photo in word for resume - Guide
- Insert draft watermark in word on all pages - Guide
- Delete my whatsapp account without app - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 12, 2017 at 11:05 AM
Oct 12, 2017 at 11:05 AM
Hi Ehsan,
Do you know you can select multiple sheets by holding the Ctrl key?
You can also use the following codes:
You can assign codes to buttons or create shortcut keys for easier acces.
Keep in mind that using codes cancels the use of the blue arrows (reverse actions). Selecting multiple sheets with Ctrl key doesn't.
Best regards,
Trowa
Do you know you can select multiple sheets by holding the Ctrl key?
You can also use the following codes:
Sub InsertSelection()
Dim ws As Worksheet
Set ws = ActiveSheet
Sheets(Array("Sheet one", "Sheet two")).Select
Selection.Insert
ws.Select
End Sub
Sub DeleteSelection()
Dim ws As Worksheet
Set ws = ActiveSheet
Sheets(Array("Sheet one", "Sheet two")).Select
Selection.Delete
ws.Select
End Sub
You can assign codes to buttons or create shortcut keys for easier acces.
Keep in mind that using codes cancels the use of the blue arrows (reverse actions). Selecting multiple sheets with Ctrl key doesn't.
Best regards,
Trowa
