Sorry, I still got it wrong. I am using Excel 97 and the RefersT
argument has to be a string. So something that comes out like this i
correct :-

RefersToR1C1:="=" & ActiveSheet.Name & "!" & "R1C8:R20C8"

So in the Insert/Name .. box it shows as something like :-
=Sheet1!$H$1:$H$2

--
Message posted from http://www.ExcelForum.com