Thread: address
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default 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?