Duplicate Range names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 20 Jun 2007 23:19 GMT

Suppose I have Sheet1 containing a named range, "Something". If I copy to a
new sheet (Edit | Move or Copy Sheet), the new sheet also contains
"Something", and I can reference either one (Sheet1.Something or
Sheet2.Something). So far so good.

Now, I need to programmatically create multiple sheets, each of which
contains "Something". How would I define Something on each sheet?

TIA,
Jim

Reply to this Message

Bob Phillips - 21 Jun 2007 08:12 GMT

With Worksheets("sheetname")
.Range("A1:A10").Name = "'" & .Name & "'!Something"
End With

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Suppose I have Sheet1 containing a named range, "Something". If I copy to
> a new sheet (Edit | Move or Copy Sheet), the new sheet also contains
[quoted text clipped - 6 lines]
> TIA,
> Jim

Reply to this Message

Jim - 21 Jun 2007 21:06 GMT

Works great. Thanks.

> With Worksheets("sheetname")
> .Range("A1:A10").Name = "'" & .Name & "'!Something"
[quoted text clipped - 10 lines]
>> TIA,
>> Jim

Reply to this Message