Problems Creating a New Named Range in VBA

[thisisnotluisa]

Hello! I'm having issues creating a named range in excel.

Here's my Code in VBA:

Public Sub Range_Very_Large()


ActiveWorkbook.Names.Add Name:="very_large", _
RefersTo:="='UK WWTWs'!$B$334:$B$" & Sheets("Business Model").Range("F40")


End Sub

When I go into a cell on a sheet and put =very_large I keep getting #NAME! and when I go to name manager the name isn't there.

 

[mole999]

creating the two sheets you have indicated and adding 5000 to F40 the code does exactly as expected, typo or missing value ?

 

[thisisnotluisa]

I made a typo. *sigh*
Thank you!