address

[darkmooink]

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?

 

[JW]

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

 

[darkmooink]

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

that realy helps, thanks