Hello and welcome
Note that for any help, it is better to join an excel file to explain and show what you need.
anyway:
i guess that F and AZY are the columns you want to delete in row 2 or 6
many choices
rows(2).delete==> the whole row will be deleted ==>previous row 3 become 2
range("F2:AZY2").clearcontents==> clear the content (not the formatting) range "F2:AZY2" without deleting the row:=> you will have an empty range
range("F2:AZY2").clear===> clear content and formatting
range("F2:AZY2").delete ==> delete the range==> makes a shift between rows..