Kevin H. Stecyk -

What I want to do is create a range name that is both local to the sheet
AND hidden.
ActiveWorkbook.Names.Add Name:="Sheet1!Blah", Visible:=False,
NameLocal:=True, RefersToR1C1Local:="=Sheet1!A25:B25"
It is now both local and hidden. So that works.

If the sheet is active, another approach is to use ActiveSheet.Names.Add
...., in which case you don't need to include Sheet1! in the Name argument.

- Mike

www.mikemiddleton.com