hendrikbez
Board Regular
- Joined
- Dec 13, 2013
- Messages
- 95
- Office Version
- 2021
- Platform
- Windows
I am trying to delete columns from one of my sheets, but cannot get it to delete, I have tried with sheet6 and insert(sheet name)
I have put a button on sheet5 t5o delete columns on sheet6(Insert), but it is not working
I have put a button on sheet5 t5o delete columns on sheet6(Insert), but it is not working
VBA Code:
Sub Del_columns()
Dim sourceSheet As Worksheet
Set sourceSheet = Sheet6
sourceSheet.Columns("H:Z").EntireColumn.Delete
End Sub
Code:
Sub Del_columns()
Dim sourceSheet As Worksheet
Set sourceSheet = Insert
sourceSheet.Columns("H:Z").EntireColumn.Delete
End Sub