ot;, the
shortcut version of the Range Object works as it normally does.
using [] for a Sheet defined named range does not work
if you're in another sheet.
interesting...
Paul
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Mon, December 21, 2009 12
ned named range does not work
if you're in another sheet.
interesting...
Paul
____________
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Mon, December 21, 2009 12:00:41 AM
Subject: $$Excel-Macros$$ Named ranges in macros
Hi XL'ers
Hi XL'ers
I am using XL2003
This is a follow-on from a previous post.
I refer to the use of the following (meaningless) Worksheet Window macro:
Private Sub Worksheet_Activate()
With Range("CompNames")
End With
End Sub
If the named range (CompNames) is on the sheet being actived, the
