Ron,
Thanks very much it works and is excellent... is there a way to only run a
macro once... i.e if the routine has ran and all the sheets have been
created, I do not want the marco to be able run again? until the next time I
open a new sheet

Regards - Paul