LinkBack URL
About LinkBacks
hotelguy 
Hi,
INDIRECT() won't work with closed workbooks. Why not have a macro that opens the workbook and then builds the Indirect() functions?
Hi,
INDIRECT() won't work with closed workbooks. Why not have a macro that opens the workbook and then builds the Indirect() functions?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Made a rookie typo - it's all in one workbook and I'm referencing different sheets. Hopefully that can make it work without having to dive into macros (I'm net quite there yet!).Originally Posted by Richard Buttrey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks