View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom tom is offline
external usenet poster
 
Posts: 570
Default 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