ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   setting print areas, and not printing 'hidden' cells (https://www.excelbanter.com/excel-programming/337062-setting-print-areas-not-printing-hidden-cells.html)

tom

setting print areas, and not printing 'hidden' cells
 
i am trying to print out a complete sheet, regardless of its size. i am doing
the below code, which i think is working.

local nrows
nRows = oSheet.usedrange.Currentregion.Rows.Count
osheet.printout(nrows)

However, it also will print out column 'h' which is hidden. can i stop that
row/column from printing and still have a print area that will grow and
shrink with the size of the data?

i am using VFP6, thanks in advance.
Tom


All times are GMT +1. The time now is 05:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com