Jim,

That was it! Thanks

Bob



"Jim Cone" wrote:

Change .Clear to .ClearContents
--
Jim Cone
Portland, Oregon USA


"robert morris"

wrote in message
Jarek,
Works almost perfectly. Random Numbers are perfect however,
when applied, I lose my Formatting for the "Range" on both the Col and Row.
Why would this happen?
Sorry for my delay in replying, I fell asleep.
Bob