Hi,
Thanks for your help on this. I'll do it the way shown for now. Just one minor addition to my code... I know i can use vba to print a sheet, nut can I do that if the sheet is hidden.
So instead of selecting the sheet ofter updating the fields, just print it.
regards
Trevor