VBA snippet:

week = InputBox("Enter the week number", week)
ActiveWorkbook.Names.Add Name:="Eddie", RefersToR1C1:="='11'!R2C2"

Two things I need to do:

1. Substitute week for '11' (having syntax problem).
2. AND week with Eddie (for example =" "Eddie" & week")