Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Lookup and Reference > ADDRESS
 

ADDRESS(row_num, column_num [,abs_num] [,a1] [,sheet_name])

 
 Returns the cell reference given a row and column number.

 row_numThe row number to use in the cell reference between 1 and 65,536.
 column_numThe column number to use in the cell reference between 1 and 256.
 abs_numThe number indicating the type of reference to return:
1 = absolute ($A$1)
2 = absolute row/relative column (A$1)
3 = relative row/absolute column ($A1)
4 = relative (A1)
 a1True of False to specify either the A1 or R1C1 reference style.
 sheet_nameThe name of the worksheet to be used as the external reference.

 REMARKS
 
  		• If "row_num" < 1, then #VALUE! is returned.
     
  		• If "col_num" < 1, then #VALUE! is returned.
     
  		• If "abs_num" is left blank, then 1 is used.
     
  		• If "a1" = True then the A1 style reference is returned.
     
  		• If "a1" = False then the R1C1 style reference is returned.
     
  		• If "a1" is left blank, then True is used.
     
  		• If "sheet_name" is left blank, then the cell reference will refer to the active sheet.
     
  		• The "sheet_name" does not have to be the name of a worksheet that actually exists.
     
  		• The "row_num" can be a cell reference that evaluates to a number.
     
  		• The "col_num" can be a cell reference that evaluates to a number.

     EXAMPLES
     
     AB
    1=ADDRESS(2,3) = $C$26
    2=ADDRESS(2,3,1) = $C$213
    3=ADDRESS(2,3,2) = C$2 
    4=ADDRESS(2,3,3) = $C2 
    5=ADDRESS(2,3,4) = C2 
    6=ADDRESS(B1,3,4) = C6 
    7=ADDRESS(2,B2,4) = M2 
    8=ADDRESS(2,3,2,FALSE) = R2C[3] 
    9=ADDRESS(2,3,1,FALSE,"[Book1]Sheet1") = [Book1]Sheet1!R2C3 
    10=ADDRESS(2,3,1,FALSE,"Excel Sheet") = 'Excel Sheet'!R2C3 
    11=ADDRESS(2,2,2,1,"worksheet_name") = worksheet_name!B$2 
    12=ADDRESS(-1,2) = #VALUE! 
    13=ADDRESS(2,-1) = #VALUE! 
    14=ADDRESS(-1,-1) = #VALUE! 
    		 
     Functions - A | Index - A | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top