Could someone please help me with the following problem. I have a macro which prints about 8 items of data from worksheet 1 to worksheet 2 then prints out worksheet 2 with the data (all in the same workbook). What do I need to add so that the macro will only print workwheet 2 if there is an 'E' in column 'C' and for any E's that may be in rows 3-60 on worksheet 1, i.e if all column 'C' rows 3-60 have E's in the I would print off 58 different worksheet 2 sheets. Maybe an 'if- then' statment for range (3-60) but how do I write this statement?

Many thanks
stge