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 |
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 |
All times are GMT +1. The time now is 06:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com