Sub Canc_B_H() Dim Nriga As Long Nriga = ActiveCell.Row Range(Cells(Nriga, "B"), Cells(Nriga, "H")).ClearContents End Sub
Option Explicit Sub cancellarighe() ' mariventi su selezione di una o più righe Dim myaddress As String, a1 As String, a2 As String, x As Integer Dim Nriga As Long Nriga = ActiveCell.Row On Error Resume Next myaddress = Selection.Address(False, False) x = InStr(myaddress, ":") a2 = Mid(myaddress, x + 1) a1 = Left(myaddress, Len(myaddress) - Len(a2) - 1) myaddress = "B" & a1 & ":" & "H" & a2 Range(myaddress).ClearContents End Sub