delete all the ranges that related to spesific sheet via macro
 

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.

delete all the ranges that related to spesific sheet via macro
 

Hi Miri,

It is usually much easier for people to help when we have your initial
attempt to work from.
Can you please post your recorded code?

Rob

__________________
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


"Miri" wrote:


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.

delete all the ranges that related to spesific sheet via macro
 

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.