Hi,
the indirect is as powerful as confusing. I know how to reference a sheet when it is for example "sum(indirect...." but know I have a huge named_range formula which starts with indirect and when I activate sheet1 the named range does not work anymore...
Please Login or Register to view this content.
When I try to put "sheet2'! in front it doesnt work at all.
indirect named.range different sheet.xlsb named_range "status1" is the important one and I want to use this range in sheet1 to select the stuff on sheet2
Bookmarks