Print Pages by Using Macro

Hi,
Can anyone tell me what is the code for Macro to print selected sheet and pages based on input number.

For example :
in cell A1=1
When I run the macro, it will print page 1

in cell A1=2
When I run the macro, it will print page 2

A1 is manual typed number to determine which page to print

Bump no response

Maybe this to print the sheet indexed by the value in cell A1 on the Sheet(1):

Please Login or Register  to view this content.

Pardon me,
that seems not working.

I want a macro for example :
Print Document Page (A1).

In A1 when I type 1 (one) then the macro will print current sheet page 1.
In A1 when I type 2 (two) then will print current sheet page 2.

That macro you give me seems do nothing. I run the macro but nothing happens (fill the A1 with 1 should print page 1, but nothing happen)

Are you taking about Worksheets or pages from one worksheet?

Pages from one worksheet.
Page to print determined by value enter in A1

This is untested

Please Login or Register  to view this content.

Hi,
I Assign the macro to a button and I put the button in Page 3 of the sheet.
in A1 I fill 2 and run the macro (should print page 2, but the macro print page 3 instead)

Try changing to this

Please Login or Register  to view this content.

Hi No Luck,
I fill 1 in A1, but it keep print page 2 when i click the button

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

OK see the attachment :S

I think this is what you want

Please Login or Register  to view this content.

That reference is found inside of a WITH .... END WITH section. Each those dot references are like an extension of the parent found on the WITH... line, equivalent to:

Please Login or Register  to view this content.

Oh, at last. . .
Thanks