Setting Print area with VBA code on active sheet - Can't get my code to work

**hans302** · 11-12-2017, 05:26 AM

Hi - I have some code that I hoped would set the Print area of the active sheet to a range of cells and then Page Set Up to print on page 1 of 1 centred both Horizontally and Vertically.

Got a bit lost - any help please?

Here is my attempt at the code !

Please Login or Register  to view this content.

Thanks in anticipation
Hans302

**davesexcel** · 11-12-2017, 06:39 AM

You need to say ".Address" to set the print area or "$F$5:$S$69"

For example:

Please Login or Register  to view this content.

**hans302** · 11-14-2017, 05:07 AM

Many thanks !!

Setting Print area with VBA code on active sheet - Can't get my code to work

LinkBack

Thread Tools

Rate This Thread

Display

Setting Print area with VBA code on active sheet - Can't get my code to work

Re: Setting Print area with VBA code on active sheet - Can't get my code to work

Re: Setting Print area with VBA code on active sheet - Can't get my code to work

Thread Information

Users Browsing this Thread

Similar Threads

VBA code to have print button and print the required area in sheet.

[SOLVED] Code to execute multiple tasks such as deleting rows, inserting sums, setting print area

Setting print area with code

Print Area:What would be the code for setting the print area

Changing code that set's print area...to active sheet only

Setting more parameters with Print area code

Help with code setting print area

Bookmarks

Bookmarks

Posting Permissions