Right, it was macropod's solution. But Paul, I don't see why you told him it would work with .xlsx files. Your solution is a user-written function, which by definition (right?) means it has to be stored in an .xlsm. Now, I'm all for that; these days I sometimes store a new workbook as .xlsm even though I haven't yet written or imagined any code for it, just because experience leads me to believe I will sooner or later. But how would your macro work with an .xlsx?
And shabbaranks, if you really can't use .xlsm, why not store it as an .xls? That'll allow embedded VBA.
|