I have 2 values lngLastRow and lngLastColumn, and what I would like to do is clear the cell contents from C2 the corresponding cell for lngLastcolumn lngLastRow.
Any idea how to do this
so if lngLastRow = 5 and lngLastColoumn = 4 I'd like to ClearContents for Range("C2:E5")
Any idea how to do this
Code:
lngLastRow = Sheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row
lngLastColumn = Sheets("Sheet1").Cells("1", Columns.Count).End(xlToLeft).Column
so if lngLastRow = 5 and lngLastColoumn = 4 I'd like to ClearContents for Range("C2:E5")