G
Gord Dibben
You can copy the UDF into a general module in your Personal.xls which will
make it available for all open workbooks.
You could copy/paste it into a general module in a new workbook, save that
workbook as an Add-in which you would load through Tools>Add-ins.
I prefer the Add-in method so's I don't have to preface the Function with
the workbook name.
i.e. if saved in Personal.xls you must enter
=Personal.xls!ConCatRange(range)
If stored in the add-in =ConCatRange(range) is sufficient.
Gord
make it available for all open workbooks.
You could copy/paste it into a general module in a new workbook, save that
workbook as an Add-in which you would load through Tools>Add-ins.
I prefer the Add-in method so's I don't have to preface the Function with
the workbook name.
i.e. if saved in Personal.xls you must enter
=Personal.xls!ConCatRange(range)
If stored in the add-in =ConCatRange(range) is sufficient.
Gord