Thanks for responding. The rule that will work with this spread sheet data
is "If there is NO data in columns A through AC, consider the row blank and
delete it" Can this be done? Thanks again...j
--
Thanks in advance...j


"JLatham" wrote:

We need some kind of rule to follow to decide if a row is considered 'blank'
or not. If not a single column, then perhaps empty cells in any one of
several different colums, as
if a4 is empty, or g4 is empty or i4 is empty, then delete row 4 completely,
or
a combination of columns, as
If a4 and i4 are empty, or g4 and k4 are empty, then delete row 4 completely.


"JCG" wrote:

Greetings:

I have a spread sheet with data that has multiple blank rows that I would
like to delete with a macro. Each row of data is different with columns that
may or may not be blank. Therefore, I cannot search on a specific column to
delete the row. Any help is appreciated.
--
Thanks in advance...j