but it also highlights the problem with Help Files, sometimes they are just too damn deep, when all you really want is a basic - like my prob.
the excel help on "printing" doesn't go anywhere near the .PrintOut suboption.
take your point on macros though, used the technique loads of times, don't know why i didn't think to try it this time. oh, well.
anyway it was to do with an earlier thread regarding printing lottery draw entry tickets, and I've got the printout sussed, my local tested it today (just the numbers i chose were wrong the actual printout worked fine, even though he fed it in the machine backwards).
now need to work more on the front end, linking into a database perhaps of multiple entries, each 7 producing a slip that will pass through the Camelot machine.