[RESOLVED] Delete Row based upon Condition?

[MSlattery]

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

[westconn1]

for a single row

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