Naming cell with a mix of variable and constant

[DroZ3]

Hi Guys,

I am trying to "name a cell" using a name which made of both a variable and a constant.

Variable is the name of the sheet :
Dim strCurrentAppliName As String
strCurrentAppliName = ActiveSheet.Name
' Here the name of the sheet is Appli_1 so strCurrentAppliName is = to Appli_1

Line of code :
ActiveWorkbook.Names.Add Name:="strCurrentAppliName + & AdminFees", RefersToR1C1:="='DATA Backup'!R121C4"

So if the line of code was good, cell R121C4 would be renamed "Appli_1AdminFees"

But the code bugs, can I get suggestions to make it work.

Note : I tried ActiveWorkbook.Names.Add Name:="strCurrentAppliName + & "AdminFees", RefersToR1C1:="='DATA Backup'!R121C4"
It does not work either.

Thanks for the help.

 

[Joe4]

It is important to note that everything between double-quotes is literal text. All variables and operators must be OUTSIDE of the double-quotes, i.e.

ActiveWorkbook.Names.Add Name:=strCurrentAppliName & "AdminFees", RefersToR1C1:="='DATA Backup'!R121C4"

 

[DroZ3]

Thanks Joe4

 

[Joe4]

You are welcome.