Building an address

[geofferrington]

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

 

[stevebriz]

Set s = Worksheets(Sheets("Notes").Range("D30").value)

 

[geofferrington]

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

Geoff

Set s = Worksheets(Sheets("Notes").Range("D30").value)