If you use zero as the seed, the computer clock initializes the stream, and the stream of random numbers is not replicable. Each random-number function and CALL routine generates pseudo-random numbers ...

In a blog post, Microsoft unveiled the TRIMRANGE function. It basically acts as an enhancement to the existing LEN function ... Microsoft does not recommend using it in critical workbooks.