Hi all,

Simple question. Is it possible to make a hash value (is that the
correct phrase?!) of a range of cells in vba?

Suppose I had the following ranges:

range1:

range2:

I want to be able to create unique number which describes each of
these ranges. In the case above, I cannot just sum the ranges as they
would not be uniquely described (i.e. the sum of each range is three,
yet the ranges are different). Ultimately the hash value will be used
to see if any cell in a range has changed since the time the last
document was saved.

I know that it would be quite easy to write a custom function to do
this which takes the range as a parameter - I just wanted to cehck to
see whether there was a native excel / vba one before doing this, as
neither the help google have offered one yet...

Many thanks,

Chris