How do I create a Range Name?

  • Thread starter Thread starter Curious
  • Start date Start date
C

Curious

I want to create different ranges of cells to capture the content and
duplicate on another sheet or workbook using a macro.
 
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)
 
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"
 
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
 
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.
 
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.
 
I wouldn't use ctr+c as it is already used by excel.

Sub copyrangebyname()
Range("character").Copy Range("g1")
End Sub
 
Back
Top