Oops. Sorry about that, don't know what I was thinking there. Rather than
Activesheet, it would be better to refer to Me, they should be the same
object, but it is the 'proper' way of doing it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Gert" wrote in message
ups.com...
Thanks Bob,

with a small adaption it works perfect

I have replaced: sh.Name = Sheet" &.Value
by: Activesheet.Name = Sheet" &.Value

regards
Gert