I want to grab the text from a named range in vba, something like:

Range("budget_100").value
Where "budget_100" is a named range in my file and I want to be able to work with the text in VBA (i.e. it refers to a sheet name and I want to be able to work with that sheet name).

Thanks!

Jon