Turn on the macro recorder and do it manually. Review the recorded code to
see how it is possible.

--

Regards,
Nigel




"Miri" wrote in message
...
hi
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?

i found the way to delete it according to the name.... it is not good
enough
for my needs...
ActiveWorkbook.Names("vvv").Delete
--
Miri Tz.