Macro to Import User defined range to Name Manager

Hi,

I'm new to Macro's , i got a macro to Define names and functions from a sheet Range to Name Manager ; the code is as below

Please Login or Register  to view this content.

What i had tried to do is ,
get the range from cell D3(F3-F5) ie., D3 = K , F3 = 10 , F5 = 20 ,
then range list is to take K10:K20 strings and delimited by = (by split function)
which forms name = function ;

but unfortunately, the function added in the name manager has "" , (like name="function" , where name=function was defined as string in K10-K20 range, which kills the usage the name manager.

can someone guide to eliminate the "" in this code.

Hi VMG,
welcome to this forum.
What's in cells K10:K20?
Or better, can you upload your workbook.

To get proper names I think you should change this line in the macro

Please Login or Register  to view this content.