I know this is an old thread and this is my first post, but I was trying to figure out how to do this without an array as well for excel web app in sharepoint. So this answer didn't work for me either, as there are no named ranges in excel. Anybody have an idea?
Bookmarks