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.

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.

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.