No, I'm using the original sheet that you first wrote the code for.
I've reattached it to be sure.

In sheet 1 of the attached file I have a name defined as results at
=Sheet1!$B$2:$D$13 and a name defined as summary at
=Sheet1!$B$15:$D$18. Is that what you expected

Attachment filename: bjl test wl.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61468
--
Message posted from http://www.ExcelForum.com