ADDRESS(row_num,column_num,abs_num,a1,sheet_text) returns a reference as text to a single cell in a worksheet : ADDRESS « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial

Home Microsoft Office Excel 2007 Tutorial 1. Introduction 2. Editing 3. Format Style 4. Table 5. Chart 6. Formula 7. Workbook Worksheet 8. Wordart Clip Art Shape Picture 9. PivotTable PivotChart 10. Data Analysis 11. Macro ActiveX Add in 12. Security 13. Collaboration 14. Database functions 15. Date Time functions 16. Engineering functions 17. Information functions 18. Logical functions 19. Lookup Reference functions 20. Math Trigonometry functions 21. Statistical functions 22. Text functions VBA / Excel / Access / Word Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Word 2007 Tutorial

Microsoft Office Excel 2007 Tutorial » Lookup Reference functions » ADDRESS   19.1.1.ADDRESS(row_num,column_num,abs_num,a1,sheet_text) returns a reference as text to a single cell in a worksheet abs_num specifies the type of reference to return. 1 or omitted, returns Absolute 2, returns Absolute row; relative column 3, returns Relative row; absolute column 4, returns Relative If a1 is TRUE or omitted, ADDRESS returns an A1-style reference. If a1 is FALSE, ADDRESS returns an R1C1-style reference. sheet_text is the name of the worksheet. Referenced from Excel Help 19.1.ADDRESS 19.1.1. ADDRESS(row_num,column_num,abs_num,a1,sheet_text) returns a reference as text to a single cell in a worksheet 19.1.2. =ADDRESS(2,3) returns Absolute reference 19.1.3. =ADDRESS(2,3,2) return absolute row; relative column 19.1.4. =ADDRESS(2,3,2,FALSE) return absolute row; relative column in R1C1 reference style 19.1.5. =ADDRESS(2,3,1,FALSE,"[Book1]Sheet1") return absolute reference to another workbook and worksheet 19.1.6. =ADDRESS(2,3,1,FALSE,"EXCEL SHEET") return absolute reference to another worksheet 19.1.7. Return a worksheet column letter (ranging from A to XFD) for the value contained in cell A1.