Printing sheets based on a cell value
 

I have a workbook of about 30 sheets; each sheet has a date in K4, the value
of which varies from sheet to sheet.

I'm hoping for a method to cycle through the workbook and print the pages
for which K4 equals a specific date such as 12/31/09.

I've tried to Name a 3-D selection (K4 on each sheet) without success. I
have cycled through rows on a single sheet before but I don't know how to
cycle through sheets and then look at 1 cell on each. Can anyone help?

Thanks in advance.
--
- markvi

Printing sheets based on a cell value
 

Hi Mark

See
http://www.rondebruin.nl/print.htm#every



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"markvi" wrote in message ...
I have a workbook of about 30 sheets; each sheet has a date in K4, the value
of which varies from sheet to sheet.

I'm hoping for a method to cycle through the workbook and print the pages
for which K4 equals a specific date such as 12/31/09.

I've tried to Name a 3-D selection (K4 on each sheet) without success. I
have cycled through rows on a single sheet before but I don't know how to
cycle through sheets and then look at 1 cell on each. Can anyone help?

Thanks in advance.
--
- markvi