490492 Excel 2007 - VBA Macro for Print

. What I need is a VBA Macro (Module) that solves the following task: I have an Excel sheet that calculates and fills cells after I entered 1 value in one cell (=$A$2). Afterwards I want that several ranges are printed one after the other , each range on a separate page - maximum 8 pages by one value entered in A2. The header name of these pages is created from the following values: $A$2 $B$2 Current Date ([login to view URL]) PageNo Example: 92224 Amberg 10.04.11 Page 1 No other general info on these pages and no grid. Page 1: A1:H36 Page 4: A37:H71 Page 3: A72:H100 Page 4: A101:H132 If value of $B$2 = 0 -> no more pages are printed If value of $B$2 = 1 -> 4 more ranges are printed on 4 pages Page 5: O1:J36 Page 6: O37:J71 Page 7: O72:J100 Page 8: O101:J132 Plus I want a routine that I can enter from 1 up to 10 different values in cell $A$2 and that these are worked on 1 by 1 and thus producing maximum 10 x 8 pages = 80 Pages For an Excel expert this project should take some minutes only. Thanks for your bids!