ExcelBanter - Can Excel automatically select print area on non-blank cells?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can Excel automatically select print area on non-blank cells? (https://www.excelbanter.com/excel-discussion-misc-queries/226598-can-excel-automatically-select-print-area-non-blank-cells.html)

N.F. Jackson[_2_]

Can Excel automatically select print area on non-blank cells?

Gord Dibben

Can Excel automatically select print area on non-blank cells?

Excel tries to give you the used range as a print range, but not always spot
on.

Non-contiguous ranges can cause problems with Excel's guess.

Gord Dibben MS Excel MVP

On Fri, 3 Apr 2009 08:19:02 -0700, N.F. Jackson
wrote:

All times are GMT +1. The time now is 01:42 AM.