Thread
:
How do I create a Range Name?
View Single Post
#
6
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
How do I change a macro to use a RangeName?
If you want help with code, post it for comments.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Curious" wrote in message
...
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett