thank you very very verrrryy muchhhh
it is very simple good and flexible way
again thanks..

No probs -- it can be pretty tricky sometimes to get one's head around these
things.

Oh, and a tip for the futu try not to rely too heavily on "implicit
objects", i.e., when you refer to for example a Range, try to write something
like:

Worksheets("Sheet1").Range("A1:E5")

Or maybe even:

Sheet1.Range("A1:E5")

Because if you only write:

Range("A1:E5")

....then you're implicitly refering to your active sheet, but the active
sheet may currently be a chart, in which case this call will fail miserably
(this was what happened in your code) -- and in some situations you may not
even have an active sheet! Dropping the object qualifier is a common way of
doing things in Excel VBA code, and it causes much confusion and plenty of
bugs.

So, my advice is: when programming, always say what you mean, and mean what
you say -- be explicit about which objects you're working with. Avoid
implicit references to objects, because by dropping the object qualifier
you're suddenly making assumptions, and assumptions are error-prone.

Good luck with your Excel hacking :o)
/MP

"premuratus" wrote:

thank you very very verrrryy muchhhh
it is very simple good and flexible way
again thanks..

thank you again...
i got the message..
thanks thanks thanks thanks thanks thanks...