Prev: Autofilter macro
Next: VLOOKUP VALUE ERROR
From: markvi on 25 May 2010 12:06
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
From: Ron de Bruin on 25 May 2010 12:36
Hi Mark

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



--

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



"markvi" <markvi(a)discussions.microsoft.com> wrote in message news:67E2DFAD-31E3-47D9-80D5-58DCBD20E0D2(a)microsoft.com...
> 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
 | 
Pages: 1
Prev: Autofilter macro
Next: VLOOKUP VALUE ERROR