| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
address
What is the use of the address function, I've not been able to use it
within another formula? The only thing it dose that I can see is that it tells the person reading the spread sheet where to look. Am I doing something wrong or is this function near to useless? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
address
You talking about in Excel or in VBA? I'm assuming Excel.
The Address worksheet function does nothing but give you the absolute address of a cell. If you want to use an address located in a cell within a formula, have a look at the INDIRECT function. HTH wrote: What is the use of the address function, I've not been able to use it within another formula? The only thing it dose that I can see is that it tells the person reading the spread sheet where to look. Am I doing something wrong or is this function near to useless? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
address
On May 30, 2:34 pm, JW wrote:
You talking about in Excel or in VBA? I'm assuming Excel. The Address worksheet function does nothing but give you the absolute address of a cell. If you want to use an address located in a cell within a formula, have a look at the INDIRECT function. HTH wrote: What is the use of the address function, I've not been able to use it within another formula? The only thing it dose that I can see is that it tells the person reading the spread sheet where to look. Am I doing something wrong or is this function near to useless? that realy helps, thanks |
| 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
