[RESOLVED] Delete Row based upon Condition?

Is this possible to delete all cells in a range based upon a condition set up in my code.

By "Delete" I mean remove the row(s) (FT:GA) and colapse the remaining data, moving it up into the deleted cells.

If this is possible, can someone provide me with the correct syntax?

Excel for Mac, 2011

Thanks, Michael

for a single row

Code:

---

If y = y Then  ' some criteria
    Range(Cells(rw, "FT"), Cells(rw, "GA")).Delete xlshifup
End If

---

i do not use a mac, but assume the same code will work, where rw is row number