Hi Dave,
Need a couple of pieces of information.
1. Is there a column that always has data in it? If so, which column?
2. Which column do you want to test for data entry?
--
Ken Hudson


"th3p3st" wrote:


Need help creating a printing macro that will automatically detect if
any information was entered into a column and if there was no
information entered i want it to delete that whole row and move the
next up. this is becuase i have pages and pages of parts and we might
only mark 1 per page. it takes to long to sort through all the unused
rows.

Thanks

Dave


--
th3p3st
------------------------------------------------------------------------
th3p3st's Profile: http://www.excelforum.com/member.php...o&userid=27666
View this thread: http://www.excelforum.com/showthread...hreadid=471786