Print multiple excel sheet according cell value

[HaroonSid]

hello, good afternoon

i have a excel file with multiple sheet,

i want all sheet print out according to there cell w4

for example,
sheet 1 and cell w4 has value 2.
the print 2 pages of sheet 1

sheet 2 and cell w4 has value 5.
the print 5 pages of sheet 2

sheet 3 and cell w4 has value 1.
the print 1 pages of sheet 3



all time sheets name changes according my need,

i want print all sheets at a time but all sheets cell value of w4.


thanx in advance

[bakerman2]

Try this one.

Please Login or Register  to view this content.

[HaroonSid]

THANX
bakerman2

will try

[HaroonSid]

this time not working
sorry

[bakerman2]

Maybe telling what exactly is not working might help us find a solution.

[HaroonSid]

dear sir
i want for example this time i have 7 sheets in my workbook, the first go 1 sheet and check the value of cell w4 and print pages according of cell value w4, after this go to 2nd sheet and check the value of cell w4 and print pages according to cell value w4, and continue...
i meant every sheets w4 value will change all times

thanx

[bakerman2]

So if I understand correctly Range("W4") gives the number of pages from each sheet.
So if Range("W4") = 3 printing will be from page 1 to 3 of that sheet.

Please Login or Register  to view this content.

[HaroonSid]

Ok
working now
tahnx
will add rep+

[bakerman2]

You're welcome and thanks for adding rep points.