Marilyne

What is the exact error message that you are getting? Is it a compile error
or a run-time error?

Is there any chance that the cells contain text and not numbers?

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Marilyne" wrote in message
...
I'm confused... It doesn't work...

I copied the exact formula but it stop compiling data there, saying that
there is incompatibility...

MaxVal = Sh.Range(cell.Address).Value
MaxSh = Sh.Name

I have very small programing knowledges and my jobs depend on that work...
So please could you help me again.

Thank you very, very much!!

Marilyne