jazzyt2u
12-09-2009, 04:44 PM
Hi,
What code would I use to find out what page a cell (using activecell) I have selected will print on?
I have two sections of data and if the first part of the data doesn't go down to page two I don't need its headers. If it does I will need the headers so I need to know a way to determine when and if the first set of data goes to page two or greater.
Thanks,
Tasha
What code would I use to find out what page a cell (using activecell) I have selected will print on?
I have two sections of data and if the first part of the data doesn't go down to page two I don't need its headers. If it does I will need the headers so I need to know a way to determine when and if the first set of data goes to page two or greater.
Thanks,
Tasha