Print pages depending on range

I hope that some one can help I am attempting to do either of the 2 functions below and neither are working. I would like to either print a number of pages depending on a cell value or print a range of cells depending on a cell value. The worksheet is made up of 40 pages and every time it still prints the 40 pages regardless of wants in the cells value.

Any help will be greatly appreciated.

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

The page is set up to 40 pages long and it does not matter what I enter it still prints the 40 pages. If i set the range to a static number it will print the range but if I have to take the value from a cell it still only prints 40 pages. I would like to be able to print the number of pages depending on cell value,

Anyone's help would be appreciated.

Thanks

For your second macro I would suggest you change the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Alf

Originally Posted by Alf

For your second macro I would suggest you change the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Alf

Thanks for that but it still comes up with an error saying range of object global failed.

Regards

Does this work?

Please Login or Register  to view this content.

Alf

Alf

Unfortunately no

Set myRange = Range("A1:U" & Range("AD2"))

Still coming up with a fail. (range of object. global failed)

I thought that printing a number of pages depending on a cell value or printing a range depending on a cell value would be quite an easy task. This seems to be posing big problems.

Regards

Sorry, I'm out of ideas. Hopefully somebody else can help you.

Alf