Building an address
 

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

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

Building an address
 

Thanks Steve... It works a treat...

Geoff

stevebriz wrote:
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