What would change if the range name was not tied to the worksheet, but
global for the wookbook?

rangename would not have the sheetname as part of the string.

HTH,
Bernie
MS Excel MVP


"Barb Reinhardt" wrote in message
...
I have programmatically created a named range that is tied to a worksheet
using the following

Worksheets(sht).Names.Add Name:=rangename, RefersTo:="=" & seriesrange

What would change if the range name was not tied to the worksheet, but
global for the wookbook?

Thanks,
Barb Reinhardt