thanks ron!! now, can I ask you another thing?
now the macro runs perfectly, but can i also make sure that the copies
of the sheets are in "landscape form" as the originals?

thanks

ps ik spreek ook nederlands