Sorry for vagueness its getting towards the end of the day... :(

The code you gave me was great but how can I get it so the sheets are
not blank.

hmmm.. This is for a report i run every month - there is standard title
in the centre of the page and then the persons name and below tha a
segment where i refreash a query.

I have 1 copy of the sheet i described above but how would i get it so
that sheet was replicated throughout the workbook exactly the same on
every sheet?


is that any better?


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=471093