copying name box to another sheet
 

How could I copy the name box from a sheet to another sheet?
Ex. In sheet 1, I give A1 the name "ABC". How could this be replicaded in
the sheet 2?

copying name box to another sheet
 

Worksheets("Sheet2").Range("A1").Name = "ABC"

but this will replace the name used in sheet1 unless it was a sheet level
name.

--
Regards,
Tom Ogilvy


"radu" wrote:

How could I copy the name box from a sheet to another sheet?
Ex. In sheet 1, I give A1 the name "ABC". How could this be replicaded in
the sheet 2?