Thread
:
Worksheet and workbook name question.
View Single Post
#
2
Posted to microsoft.public.excel.programming
TH[_3_]
external usenet poster
Posts: 38
Worksheet and workbook name question.
And you can always refer to the workbook containing the macro that is
running with the ThisWorkbook keyword as in:
ThisWorkbook.Sheet1.Range("A1")
TH
On 4/19/04 14:56, in article
, "Bob
Phillips" wrote:
With worksheet, you can use the codename property. If you go into the VBE,
and look at the Microsoft Excel Objects, the codename is the left of the 2
name pairs. It is usually of the form Sheet1(Sheet1), but if the user
changes the name to mySheet, it would show as Sheet1(mySheet).
You would address the sheet like so
Sheet1.Range("A1")
etc.
Reply With Quote
TH[_3_]
View Public Profile
Find all posts by TH[_3_]