You can use an IF statement instead of indirect, but you have to have an IF to cover ALL possible sheets or ranges. That is NOT volatile but kinda messy.