and keep to the original thread, it gets confusing otherwise.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Miri" wrote in message
...

i need to delete all the ranges that related to spesific sheet. how should
i
do that?
i also need to copy all the ranges that related to spesific sheet to
another. how do i do that?

record it via macro didnt help me to find the solution... please advice
--
Miri Tz.