J JP Jan 10, 2008 #2 On Insert Menu, go to Name>Define You can type in the name and then in the "Refers To" box, enter the cell reference. HTH, JP
On Insert Menu, go to Name>Define You can type in the name and then in the "Refers To" box, enter the cell reference. HTH, JP
J JP Jan 10, 2008 #4 Can you post some more examples, there is a VBA solution that would be less tedious. --JP