range problem too
Posted by Larry on July 10, 2001 7:55 PM
I am also having problems naming the range. When I click on the cells and try to define the range name, a message pops up that says "Your formula contains an invalid external reference to a worksheet." My worksheet's name is "ISP (2)". For some reason, it is putting the worksheet address in between the cell addresses. (='ISP (2)'!$D$5,'ISP (2)'!$D$6,'ISP (2)'!$D$7,'ISP (2)'!$D$11,'ISP (2)'!$D$12,etc.)
I'm still learning this and any help would be great!
Thanks in advance!