I need to get a few specifics before I can write code for your application.

1.) So you want to delete all colored rows and all worksheets? Do you want
to delete only certain colored rows? Please be specific.

2.) You want to delete all rows that are totally empty, rows that contain
#N/A, or all rows after a certain cell in a particular column. Please be
specific.
--
Cheers,
Ryan


"Lizz45ie" wrote:

The rows that I want to delete within the workbooks are colored on each
worksheet but they are a different row in each worksheet.

The rows that I want to delete at the end of the worksheets has information
in them but not all of the cells are completed. They have a #n/a in the
cells where data is missing in the row. Hope that helps.

"RyanH" wrote:

I need help in deleting empty rows on multiple worksheets where the empty
row
is a different row number on each of the worksheets.

Are you saying you want to delete all empty rows or one specific empty row
each worksheet? If you want to delete one specific row on each worksheet you
will have to have some way of indicating to Excel where to find that row
number. Maybe by using a helper row or a interior color, etc.

I also need to delete the empty rows at the bottom of the worksheets after the last line of data.

I'm not quite sure why you want to delete empty rows below the last line.
They are empty, and if you delete them they will still remain there.

--
Cheers,
Ryan


"Elizabeth" wrote:

I need help in deleting empty rows on multiple worksheets where the empty row
is a different row number on each of the worksheets. I also need to delete
the empty rows at the bottom of the worksheets after the last line of data.