How to set PrintArea to a named range

[Osprey2]

I need to Print the data in a named range and have tried the following code to do this:-

Please Login or Register  to view this content.

When this is run the correct columns are printed but the first printed row is the row above the named range and the last printed row is the penultimate row of the named range.
When I check the range in the Name Manager I find that the named range has been changed and its value is that of the print area.
There are 67 rows to print and 20 columns most of which contain 6 digits so this is a squeeze on A4 whether Portrait or Landscape and perhaps something decides that's too much to print we have to trim it.
But how can the range values be changed? I need help please!
John

[rorya]

You should just be able to use:

Please Login or Register  to view this content.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.