M
MB
I have a number of simlar named ranges - e.g. basicsalprnaip, basicsalprtodc,
basicsalprcoco etc etc ......
I wish to create a text string within each sheet of my workbook that creates
a ref to the named range by taking the last 5 characters from the current
worksheet - e.g. prnaip in the first example above.
e.g. =basicsal&A1
(A1 cell containes prnaip)
However this does not create a formula referring to the named range. Hope
this explanation is clear!! Please help !!!
basicsalprcoco etc etc ......
I wish to create a text string within each sheet of my workbook that creates
a ref to the named range by taking the last 5 characters from the current
worksheet - e.g. prnaip in the first example above.
e.g. =basicsal&A1
(A1 cell containes prnaip)
However this does not create a formula referring to the named range. Hope
this explanation is clear!! Please help !!!