i know what you want - Word has "print current page" & i've often
wished Excel had the same thing.
i've done it on a small scale by hard-coding the row #s, such as this
(draft coding):
===========================
if activecell.row = 103 and
if activecell.row <= 135 then
print From:=3. To:=3 'i don't know the print
'structure off the top
'of my head
if activecell.row = 203 and
if activecell.row <= 235 then
print From:=5. To:=5
===========================
that type of thing........... or could make it a case statement
structure.
caveat - it will only work if no additional rows will be added in the
future, but it can be done.........
hope this helps.
susan


On May 6, 2:32*pm, Don Lowe wrote:
I am hoping to have a macro that looks at what pape I am on and will print
the specific page. This way I do not need to make 97 buttons for printing.
One button printing where ever you are (most of my users would not now where
they are and I am trying to make this really really easy for them).



"JLGWhiz" wrote:
Not sure about the current page, but in the PrintOut arguments you can
specify the From and To page numbers, so if your current page is 3 the
From:=3. To:=3 should do it.

"Don Lowe" wrote:

I have many people using the file. Each person only needs a page worth of
information. I need a Macro to print curent page only.- Hide quoted text -

- Show quoted text -