program excel worksheet to automatically not print blank rows

Take a look at Ron de Bruin's site
http://www.rondebruin.nl/print.htm
in particualr scroll down to the section
Hide Rows or Cells when you print a sheet
and insert the section Hide rows with a blank cell in column A

--
Regards
Roger Govier
<[email protected]> wrote in message
news:[email protected]...
>I have an excel spreadsheet where a pivot table is automatically
> generated that varies in length. I don't want to resize the print area
> each time. Is there a macro that anyone can share that instructs excel
> not to print blank rows?
> Thanks
>

Unless you have other data on the sheet, you shouldn't need a print
area. Clear it, then the pages to print will adjust as the pivot table
changes size.

[email protected] wrote:
> I have an excel spreadsheet where a pivot table is automatically
> generated that varies in length. I don't want to resize the print area
> each time. Is there a macro that anyone can share that instructs excel
> not to print blank rows?
> Thanks
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Take a look at Ron de Bruin's site
http://www.rondebruin.nl/print.htm
in particualr scroll down to the section
Hide Rows or Cells when you print a sheet
and insert the section Hide rows with a blank cell in column A

--
Regards
Roger Govier
<[email protected]> wrote in message
news:[email protected]...
>I have an excel spreadsheet where a pivot table is automatically
> generated that varies in length. I don't want to resize the print area
> each time. Is there a macro that anyone can share that instructs excel
> not to print blank rows?
> Thanks
>

Unless you have other data on the sheet, you shouldn't need a print
area. Clear it, then the pages to print will adjust as the pivot table
changes size.

[email protected] wrote:
> I have an excel spreadsheet where a pivot table is automatically
> generated that varies in length. I don't want to resize the print area
> each time. Is there a macro that anyone can share that instructs excel
> not to print blank rows?
> Thanks
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Take a look at Ron de Bruin's site
http://www.rondebruin.nl/print.htm
in particualr scroll down to the section
Hide Rows or Cells when you print a sheet
and insert the section Hide rows with a blank cell in column A

--
Regards
Roger Govier
<[email protected]> wrote in message
news:[email protected]...
>I have an excel spreadsheet where a pivot table is automatically
> generated that varies in length. I don't want to resize the print area
> each time. Is there a macro that anyone can share that instructs excel
> not to print blank rows?
> Thanks
>

Unless you have other data on the sheet, you shouldn't need a print
area. Clear it, then the pages to print will adjust as the pivot table
changes size.

[email protected] wrote:
> I have an excel spreadsheet where a pivot table is automatically
> generated that varies in length. I don't want to resize the print area
> each time. Is there a macro that anyone can share that instructs excel
> not to print blank rows?
> Thanks
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Take a look at Ron de Bruin's site
http://www.rondebruin.nl/print.htm
in particualr scroll down to the section
Hide Rows or Cells when you print a sheet
and insert the section Hide rows with a blank cell in column A

--
Regards
Roger Govier
<[email protected]> wrote in message
news:[email protected]...
>I have an excel spreadsheet where a pivot table is automatically
> generated that varies in length. I don't want to resize the print area
> each time. Is there a macro that anyone can share that instructs excel
> not to print blank rows?
> Thanks
>

Unless you have other data on the sheet, you shouldn't need a print
area. Clear it, then the pages to print will adjust as the pivot table
changes size.

[email protected] wrote:
> I have an excel spreadsheet where a pivot table is automatically
> generated that varies in length. I don't want to resize the print area
> each time. Is there a macro that anyone can share that instructs excel
> not to print blank rows?
> Thanks
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I have an excel spreadsheet where a pivot table is automatically
generated that varies in length. I don't want to resize the print area
each time. Is there a macro that anyone can share that instructs excel
not to print blank rows?
Thanks

Take a look at Ron de Bruin's site
http://www.rondebruin.nl/print.htm
in particualr scroll down to the section
Hide Rows or Cells when you print a sheet
and insert the section Hide rows with a blank cell in column A

--
Regards
Roger Govier
<[email protected]> wrote in message
news:[email protected]...
>I have an excel spreadsheet where a pivot table is automatically
> generated that varies in length. I don't want to resize the print area
> each time. Is there a macro that anyone can share that instructs excel
> not to print blank rows?
> Thanks
>

Unless you have other data on the sheet, you shouldn't need a print
area. Clear it, then the pages to print will adjust as the pivot table
changes size.

[email protected] wrote:
> I have an excel spreadsheet where a pivot table is automatically
> generated that varies in length. I don't want to resize the print area
> each time. Is there a macro that anyone can share that instructs excel
> not to print blank rows?
> Thanks
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html