Help with printing

[Kathryn J Bittman]

We are working on a project in Excel 2000. The problem we are trying to
solve is to have macro to print a list. However, the list will change
(shrink/grow) and we can't seem to build a macro to work. Is there
a way to build one to select a print area, then print? Needs to be a "one
click" item.

We have also tried it in Excel 2003 - still no luck.

All help is appreciated!

[Nigel]

Try using the macro recorder and then edit the resulting code, this will
give you a framework to begin developing a more complete solution

--
Cheers
Nigel



"Kathryn J Bittman" <grannybitt@msn.com> wrote in message
news:%236b0srPPGHA.3728@tk2msftngp13.phx.gbl...
> We are working on a project in Excel 2000. The problem we are trying to
> solve is to have macro to print a list. However, the list will change
> (shrink/grow) and we can't seem to build a macro to work. Is there
> a way to build one to select a print area, then print? Needs to be a "one
> click" item.
>
> We have also tried it in Excel 2003 - still no luck.
>
> All help is appreciated!
>
>

[Ron de Bruin]

Hi

If you clear your printarea (File> Print Area....Clear Print Area) it will print all data on your sheet

Or

Selection.PrintOut
'print only the selection



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kathryn J Bittman" <grannybitt@msn.com> wrote in message news:%236b0srPPGHA.3728@tk2msftngp13.phx.gbl...
> We are working on a project in Excel 2000. The problem we are trying to
> solve is to have macro to print a list. However, the list will change
> (shrink/grow) and we can't seem to build a macro to work. Is there
> a way to build one to select a print area, then print? Needs to be a "one
> click" item.
>
> We have also tried it in Excel 2003 - still no luck.
>
> All help is appreciated!
>
>