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" <(E-Mail Removed)> wrote in message
news:4AFC44E2-8EEF-4CAF-83FE-(E-Mail Removed)...
>
> 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.