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?
|