Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting print areas jaclh2o Excel Discussion (Misc queries) 5 May 2nd 07 07:18 AM
Printing Hidden Cells GPIE Excel Discussion (Misc queries) 8 March 16th 07 06:41 PM
Setting Print Areas Meredith Excel Discussion (Misc queries) 2 June 22nd 06 03:47 PM
Not printing hidden cells sarcher Excel Discussion (Misc queries) 1 May 16th 06 12:55 PM
Printing non-adjacent areas on seperate sheets in one print job Dan Knight Excel Programming 0 January 7th 04 02:51 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"