The problem is that whether the row is filled or not depends on a number of variables in the records I am sinking. And at over 300 records, manual deletion would be a pain. Does anyone know how to write the VBA code for the Hidemark property?