Print array code for a series of pages that will also determine print area required?

**matrixpom** · 11-04-2012, 07:30 PM

Good day all once again,

I have print code attached to a command button which prints a series of sheets, however some of these sheets will have a changing print area, e.g. depending on how many procedures required will determine the amount of rows that need printing, is there a code that will recognise an empty cell & make that point the print area? - Thank you all & have a great day! - Marco

Please Login or Register  to view this content.

**JBeaucaire** · 11-04-2012, 09:06 PM

I believe you can NOT set a print area at all on a worksheet and it will then result in the sheet only printing the "used range".

**matrixpom** · 11-04-2012, 09:23 PM

Thanks for the advice Jerry, guess they will just have to adjust the print area manually then

**JBeaucaire** · 11-04-2012, 10:37 PM

That's not what I was suggesting. I was suggesting you "Clear Print Area" on each sheet, then run your macro. With no specific print area, the sheet should only print the used range on each sheet.

**matrixpom** · 11-04-2012, 11:46 PM

Hi Jerry,

Sorry, had a blonde moment...works perfect! Have a great day! -Marco

Print array code for a series of pages that will also determine print area required?

LinkBack

Thread Tools

Rate This Thread

Display

Print array code for a series of pages that will also determine print area required?

Re: Print array code for a series of pages that will also determine print area required?

Re: Print array code for a series of pages that will also determine print area required?

Re: Print array code for a series of pages that will also determine print area required?

Re: Print array code for a series of pages that will also determine print area required?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions