Hi Dan
Really like your macros and tips- very thought provoking and educational- thanks.
You just posted code for the UDF in the title but am I doing something wrong perhaps?
The UDF has a range as the input parameter "rCell" (via "Function GETNUMBER(rCell As Range, Optional Take_decimal As Boolean, Optional Take_negative As Boolean) As Double") but I had to change the command "sText = rCell" to "sText = rCell.Value" to get it to work at all.
I thought VBA generally took the value as a default so was a bit surprised. I'm using Excel 2013.
Anyone else have that problem?
John