Hiya,

I think there is not much you can do if you don't want to use VBA or named ranges, but if you can post an example file maybe I can figure out another way for you.