I think you'll have to post the code you used.

And did you change this line:

if lcase(ws.name) = lcase("master") then

To use the real name of your "master" worksheet--I guessed that its name was
"master".

" wrote:

Hi Dave,
This doesnt work. Can you explpain this more . I tried to use it but it
crashed.

Thanks

--

Dave Peterson