Thank you for the answer. How would I change a macro that I recorded to use
a RangeName instead of the cell range? I am not that familiar with the VB
code.


"Don Guillett" wrote:

or, select the cells and name in the NAME box to the left of the formula
box.
To do with a macro

sheets("yoursheet").range("a2:b5").name="newname"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Curious" wrote in message
...
I want to create different ranges of cells to capture the content and
duplicate on another sheet or workbook using a macro.