Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ADDRESS Function
I posted an item below. I think the Address function is creating the formula
I need, but is there a way for it to return the value in the cell instead of the formula for the cell? From Help: =ADDRESS(2,3,1,FALSE,"EXCEL SHEET") is an absolute reference to another worksheet ('EXCEL SHEET'!R2C3) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ADDRESS Function
Its just another function:
if B2 contains: =ADDRESS(2,3,1,FALSE,"EXCEL SHEET") then you will see: 'EXCEL SHEET'!R2C3 in the cell. In B3 put: =INDIRECT(B2,A1) and B3 will show the contents of the target. -- Gary''s Student "QC Coug" wrote: I posted an item below. I think the Address function is creating the formula I need, but is there a way for it to return the value in the cell instead of the formula for the cell? From Help: =ADDRESS(2,3,1,FALSE,"EXCEL SHEET") is an absolute reference to another worksheet ('EXCEL SHEET'!R2C3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency to Text | Excel Worksheet Functions | |||
VBA | Excel Worksheet Functions | |||
ADDRESS function | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Use address function or other | Excel Worksheet Functions |