Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I create a Range Name?
I want to create different ranges of cells to capture the content and
duplicate on another sheet or workbook using a macro. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I create a Range Name?
Just select the range of cells, hit Ctrl-F3, and add a name.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I create a Range Name?
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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I change a macro for a range of cells to a RangeName?
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. Thanks "Bob Phillips" wrote: Just select the range of cells, hit Ctrl-F3, and add a name. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I change a macro to use a RangeName?
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. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I change a macro to use a RangeName?
Here is the code I have now:
ub Character() ' ' Character Macro ' ' Keyboard Shortcut: Ctrl+c ' Range("A1:C3").Select Selection.Copy Range("G1").Select ActiveSheet.Paste End Sub How do I change this to use aRangeName "CHARACTER" instead of the current cell range? Thank you for your help. "Don Guillett" wrote: 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. |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I change a macro to use a RangeName?
I wouldn't use ctr+c as it is already used by excel.
Sub copyrangebyname() Range("character").Copy Range("g1") End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Curious" wrote in message ... Here is the code I have now: ub Character() ' ' Character Macro ' ' Keyboard Shortcut: Ctrl+c ' Range("A1:C3").Select Selection.Copy Range("G1").Select ActiveSheet.Paste End Sub How do I change this to use aRangeName "CHARACTER" instead of the current cell range? Thank you for your help. "Don Guillett" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create range bar graph | Charts and Charting in Excel | |||
Create a link to print a certain range | Excel Discussion (Misc queries) | |||
Trying to create a range in an IF function | Excel Worksheet Functions | |||
Create a list range | Excel Worksheet Functions | |||
how do i create range names ? | Excel Worksheet Functions |