Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Offset function referencing worksheet
I am using the offset function, the reference is another worksheet. The
formula gives a value when the other worksheet is open but when I reopen the worksheet with the offset function referencing the other worksheet, there is a Value error. Is it not possible to use offset function referencing another worksheet? THanks |
#2
|
|||
|
|||
There are a number of functions that don't work with closed WBs, notably
Indirect(), Sumif(), and, as you've learned, Offset(). Post your formula so that other options can be suggested. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jeff" wrote in message ... I am using the offset function, the reference is another worksheet. The formula gives a value when the other worksheet is open but when I reopen the worksheet with the offset function referencing the other worksheet, there is a Value error. Is it not possible to use offset function referencing another worksheet? THanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
changing type style and colour within a worksheet function | Excel Worksheet Functions | |||
Excel 2003 worksheet name function? | Excel Worksheet Functions | |||
Troubles with the OFFSET function | Excel Worksheet Functions | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions |