Maybe you could record a macro when you applied Data|filter|autofilter to your
range. Then you could filter to show only those rows that are empty in column
M.

Print that. Then use Data|filter|showall (or even remove the filter).

Mark wrote:

I am using EXCEL 97.

Can anyone please assist me with some code which examines a worksheet and
only prints the rows in the worksheet which have an empty cell in column 'M',
but off course only examines the rows with any data in them.

Thanks in advance
--
Mark

--

Dave Peterson