Thread
:
Building an address
View Single Post
#
2
Posted to microsoft.public.excel.programming
stevebriz
external usenet poster
Posts: 195
Building an address
Set s = Worksheets(Sheets("Notes").Range("D30").value)
wrote:
I have a statement that reads:
Set s = Worksheets("Home")
In order to not have to hard code the word "Home" in this statement,
I have placed it on a sheet called "Notes" in position D30.
How do I modify the above statement so that it automatically loads the
word in that position?
I imagine that it will look something like:
Set s = Worksheets(Sheets("Notes").Range("D30"))
Thanks in advance
Geoff
Reply With Quote
stevebriz
View Public Profile
Find all posts by stevebriz