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.
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.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks