vba excel copy date multiple times code example

Example 1: excel vba get column name from number

'For column number 256...

ColName = Split(Cells(, 256).Address, "$")(1)

Example 2: delete rows in excel vba code

Sub DeleteRowswithSpecificValue()
For i = Selection.Rows.Count To 1 Step -1
If Cells(i, 2).Value = "Printer" Then
Cells(i, 2).EntireRow.Delete
End If
Next i
End Sub