I'm a macro novice and I need some help. I have a sheet called results and a print area called results analysis. Within the sheet commencing at cell J7 there is a list of around 500 names. Cell B3 within the print area should contain the name from J7. Once it has printed, B3 should contain J8 and start the print cycle again. This should continue until it reaches a cell which contains 0,0. I need a macro which can do this automatically. Without a macro, this is a laborious task. Can anyone please help?