Printing selected rows
 

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