Create a print macro that would automatically select print area?

Hi wastedwings

Can you give more information


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


"wastedwings" <[email protected]> wrote in message news:[email protected]...
> How do I create a macro to automatically select the print area that has
> contents in certain cells?

I have a worksheet that contains information that updates from another
worksheet (contains links). I print the worksheet out each time it is
updated, but I would like to create a macro that would automatically select
the print area of the cells that contain information, instead of going in and
selecting the print area. Since there are cells that do not have information,
but contain links to another worksheet for future linking, hitting the print
button will not print the cells that contain information only, but will only
print a portion of the worksheet.

"Ron de Bruin" wrote:

> Hi wastedwings
>
> Can you give more information
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "wastedwings" <[email protected]> wrote in message news:[email protected]...
> > How do I create a macro to automatically select the print area that has
> > contents in certain cells?
>
>
>

How do I create a macro to automatically select the print area that has
contents in certain cells?

Hi wastedwings

Can you give more information


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


"wastedwings" <[email protected]> wrote in message news:[email protected]...
> How do I create a macro to automatically select the print area that has
> contents in certain cells?

I have a worksheet that contains information that updates from another
worksheet (contains links). I print the worksheet out each time it is
updated, but I would like to create a macro that would automatically select
the print area of the cells that contain information, instead of going in and
selecting the print area. Since there are cells that do not have information,
but contain links to another worksheet for future linking, hitting the print
button will not print the cells that contain information only, but will only
print a portion of the worksheet.

"Ron de Bruin" wrote:

> Hi wastedwings
>
> Can you give more information
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "wastedwings" <[email protected]> wrote in message news:[email protected]...
> > How do I create a macro to automatically select the print area that has
> > contents in certain cells?
>
>
>