This may have a solution... but my search may not be using the right terminology. Most results pop up VBA based answers which is what I'm trying to avoid if possible.
I want to take a name range, like this:
='FC PARTS Analysis Data'!$A$1:$BX$1
and append a value ("FC#") to this name range array.
I've tried:
='FC PARTS Analysis Data'!$A$1:$BX$1,"FC#" -> results in array error without pop-up
='FC PARTS Analysis Data'!$A$1:$BX$1+"FC#" -> pop-up window error
='FC PARTS Analysis Data'!$A$1:$BX$1&"FC#" -> add the "FC#" text to every piece of the array.
I'm trying to do this in the fx formula bar so I can use it in the name manager. Can it be done by defining a range in vba and use Union?
I want to take a name range, like this:
='FC PARTS Analysis Data'!$A$1:$BX$1
and append a value ("FC#") to this name range array.
I've tried:
='FC PARTS Analysis Data'!$A$1:$BX$1,"FC#" -> results in array error without pop-up
='FC PARTS Analysis Data'!$A$1:$BX$1+"FC#" -> pop-up window error
='FC PARTS Analysis Data'!$A$1:$BX$1&"FC#" -> add the "FC#" text to every piece of the array.
I'm trying to do this in the fx formula bar so I can use it in the name manager. Can it be done by defining a range in vba and use Union?
