Hi

I have a workbook with lots of worksheets

How can I do the following ........

Set the print area of every worksheet in the work book to A1:A10

Enter the same text in to Cell A1

And change the colour of Cell A2 to red

I only know a little VB so please keep it simple


Thanks

Katie