Hi, i have this code and its only clearing the data in column A. All i want is to find blank cell in column A and clear 10 ROWs after that blank cell. Should clear columns A B C D E & F. Thank you.

Lastrow = Sheets("Input").Cells(65536, 1).End(xlUp).Row
Sheets("Input").Range("A" & Lastrow - 7 & ":" & "A" & Lastrow).Resize(9).Clear