I am trying to write a few dynamic lists, based on data in a sheet, using the standard
But I would like the column $A:$A to be dynamic as well based on a named variable.Please Login or Register to view this content.
i.e. the named variable is called "ListTitle"
and so code is now something like
I tried using the "address" formula, but this doesn't seem to accept anything other than a single row address, so is inappropriate.Please Login or Register to view this content.
If anybody could help, that would be great.
Bookmarks