LinkBack URL
About LinkBacks
Both OFFSET and INDIRECT are volatile functions, so you can't use them together.
However, you can use INDEX to define your dynamic range, and then you could use INDIRECT with it.
Hope this helps.
Pete
Both OFFSET and INDIRECT are volatile functions, so you can't use them together.
However, you can use INDEX to define your dynamic range, and then you could use INDIRECT with it.
Hope this helps.
Pete
Many thanks, Pete_UK. I will have a go by using INDEX to define the dynamic range.
I had a try with the INDEX function to create named range. However, this still does not work (#REF error). The example is attached here.
Last edited by BNCOXUK; 09-19-2019 at 04:53 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks