Thank you Michael for your explanation. I had no success naming a range or at least in being able to prove that I had named a range. But the real problem is that I can't copy/paste to a new book, not a new sheet. Will the querysheet function work between books or just within sheets within books. I had as much success writing the Querysheet function as I did naming a range, that is, not much. Your advice much appreciated as we are anxious to produce our financials.