Name Box......how can i enter names more efficiently?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tegant - 09 Jan 2006 18:44 GMT

Hi,

I have several field that I need to name. If I have the names of the
field in cells (in the cells, not the name box) of another worksheet,
is there a way I can copy and paste the text in the cells to the name
box of another cell? I think a macro is required for this, but I'm not
sure how to do it.

Any advice?

Thanks in advance

Signature

tegant

Reply to this Message

Otto Moehrbach - 09 Jan 2006 20:33 GMT

Something like this:
With Sheets("TheOtherSht")
Range("A1").Name=.Range("C1").Value
End With
The range without a dot in front of it (the first range above) refers to the
active sheet. The other range, that does have a dot in front of it, refers
to a sheet named "TheOtherSht".
This names A1 of the active sheet the string that is located in C1 of the
"TheOtherSht".
As you can see, this names only one range. If you have many names that you
want to use for many ranges, then you should consider using a looping code.
Post back if you need more. HTH Otto

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks in advance

Reply to this Message