On the other hand, it only requires a single change to a worksheet name -- which
makes it simpler <bg.

On 01/21/2011 15:36, GS wrote:
Dave Peterson explained :
Instead of specifying the sheetname twice, I use something like:

With Worksheets("sheet 2")
.Range("A1").Name = "'" & .Name & "'!Don"
End With



On 01/21/2011 13:14, GS wrote:
Sheets("Sheet2").Range("A1").Name = "'Sheet2'!Don"

Hi Dave,
While I agree with you in general, I posted what I posted because my point was
to give the OP the correct way to define a local name. Your suggestion does
exactly that but requires a bit of study on the part of someone not so familiar
with working with names as you & I are.<g


--
Dave Peterson