Macro to delete rows once #N/A is found in a cell

Hello,
I'm looking for a macro that scans through 5000 rows of data and as soon as it find #N/A in a particular cell under Column "C", deletes that row and the next 20 rows from the worksheet. Please help!