Identify the Book, Sheet, and Range/Cell of the cell in which a function is called

Hi,

I'm trying to write a function for worksheet use that will search through every single in cell in all open books and return the name of the book that matches the supplied value. However, the problem is that the function will always attempt to search the cell that it's called from, resulting in a circular reference. Is there a way to make the search skip over the cell that it was called from? Or alternatively, can I just have it skip over the workbook that the function is in?

Please Login or Register  to view this content.

Many thanks!

Hi,

Many thanks for the suggestion, that would certainly work in most instances, however, my function will probably live in an addin, so it returns the wrong workbook.

I've discovered an ugly solution: Have the function require a range variable, then take the workbook name from the range variable. It's a bit cumbersome, but it'll do for now.

If anyone has a better solution, I'd be keen to hear it.

Cheers!