This isn't a native excel function.

My bet is that you had another workbook (probably an addin) that had this User
Defined Function in it.

If you can find that workbook, you should (ok, may) be able to use it in xl2007.

Rouchelle wrote:

Its my first time using Excel 2007. In the old versions a function called
"Johnranges" - This doesnt exist in the 2007 version. Does anyone know
whether this has been replaced with another function in the newer version?

--

Dave Peterson