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.