Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Johnranges function.
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Johnranges function.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |