Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset Reference Cell
I am using the OFFSET function with a spreadsheet created by our IT
department. I have added the offset function to help sort the results in the spreadsheet. When initially entered the function works fine. However, when the data is updated (background macro, code is protected), the "refer to" in the named range changes to OFFSET (sheetname!#REF!). Before I go to my IT folks, I would like to understand what could be causing the reference to change. Any ideas would be appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repost: Copy and Offset cell reference | Excel Worksheet Functions | |||
Dynamic Reference Cell in Offset Formula | Excel Discussion (Misc queries) | |||
How to reference an offset from a cell? | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |