Monthly Archives: August 2014

I was never satisfied with all the stuff on the Internet about referencing Workbook Level Named Ranges in other open spreadsheets.  So a looong time ago I dinked around and came up with this syntax: Range(activeworkbook.name & “!Accounts”).address That worked great for … Continue reading →