Does anyone know if the range object is declared global by
default. that is, could I cuse the range from any where in
the workbook without keep switching to the worksheet that
the named range is located.

For example is I name a range MyRange on sheet1 could I
address that MyRange while performing some operation on
sheet2?

I hope I presented my question in an understandable format.

Thanks
Desmond