insert variable into excel property

[fanningj]

Could you please look at the code below...

Dim x As String
x = "1"

With ActiveWorkbook.Names("claim_date")
.Name = "claim_date"
.RefersToR1C1 = "='Claim ""x""'!R9C5"
.Comment =

Using this code how do I insert variable into the .refersToR1C1 property. I only want to change part of the property ie (Claim *insert number 1 or 2* 'R9C5"

thanks

 

[Jonmo1]

Welcome to the board.

Try

.RefersToR1C1 = "='Claim " & x & "'!R9C5"

 

[fanningj]

thank you very much it worked nicely