Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute cell reference will not remain absolute.
Oh Wise Ones,
Excel 2003 SP WinXP Pro I have a date in J4. If I link the contents of J4 to another workbook by using ***$J$4 and I insert a row where the date in J4 may change, my linked cell reference is now to $J$5. Why does this happen? Thanks, Mike |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute cell reference will not remain absolute.
That is what absolute reference does. When you are inserting a row, you are
actually moving the cell that it was referncing down one row, therefore, to maintain the exact cell reference, it must update the row number, as the cell moved. It sounds like you want the INDIRECT function, the row/column settings will not change. So, instead of: =IF($J$4=somevalue,iftrue,iffalse) try this: =IF(INDIRECT("J4")=somevalue,iftrue,iffalse) Hope this helps. -- John C "Mike K" wrote: Oh Wise Ones, Excel 2003 SP WinXP Pro I have a date in J4. If I link the contents of J4 to another workbook by using ***$J$4 and I insert a row where the date in J4 may change, my linked cell reference is now to $J$5. Why does this happen? Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
absolute cell reference macro | Excel Discussion (Misc queries) | |||
Absolute Cell Reference Click | Excel Discussion (Misc queries) | |||
Reference absolute cell values | Excel Worksheet Functions | |||
Absolute Cell Reference | Excel Discussion (Misc queries) | |||
Absolute cell reference question | Excel Worksheet Functions |