| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
| long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
| How to insert an address from Outlook 2003 address book ? | Excel Programming | |||
| LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info | Excel Programming | |||
Linear Mode
