defining a range of cells in excel using cell content

  • Thread starter Thread starter paul.sternhagen
  • Start date Start date
P

paul.sternhagen

I am attempting to write a macro that will name a range of cells with
the "name" for said range coming from the content of a cell.
Essentially I am trying to map a group of cells to a standard field,
and rather than do this manually, I am hoping that there is a way that
I can define the range of cells by pointing to a cell value rather than
manually entering the standard field name for the range of cells. Any
input would be most helpful. Thanks
 
Your problem statement is a bit vague, but this may get you started.

Range("B1:Z1").Name = Range("A1").Text
 
That was it. A little humbling to find that it was something this
simple all along. Thanks a lot.
 
Back
Top