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