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

T

tegant

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
 
O

Otto Moehrbach

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
 
Top