i dot know.. i have office 2007.. but when i use ; nothing happens..
but Passo find the solution and it's working..
thanx for the effort..




thnx for reply
:)


"Rick Rothstein" wrote in message
...
The formula worked fine in my tests before I posted it, so I am guessing
that your local settings do not use the comma as a statement separator
(I'm only guessing here because I don't have any experience with
international, that is, non-US, versions of Excel)... perhaps yours
statement separator is a semi-colon (;) which is a separator symbol I've
seen used in some postings? I know it wouldn't be the colon that you tried
because that would make Excel look at the "A1:B1" part of the formula that
would result from that substitution as if it were a range.

--
Rick (MVP - Excel)