Answers for "delete named range excel vba"

VBA
2

excel vba delete rows in range

' Removes 3rd row
ThisWorkbook.Worksheets(1).Rows(3).EntireRow.Delete
' Just to clear cells without removing the row
ThisWorkbook.Worksheets("Feuil1").Rows(3).Cells.ClearContents
' Removes 3rd row of a range
Range("My_RANGE").Rows(3).EntireRow.Delete
Posted by: Guest on January-15-2021
0

excel vba delete columns in range

' Deletes 3rd column
ThisWorkbook.Worksheets(1).Columns(3).EntireColumn.Delete

' Deletes 3rd column in range
Range("My_RANGE").Columns(3).EntireColumn.Delete
Posted by: Guest on January-15-2021

Code answers related to "VBA"

Browse Popular Code Answers by Language