 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007How 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. Just select the range of cells, hit Ctrl-F3, and add a name.  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >I want to create different ranges of cells to capture the content and > duplicate on another sheet or workbook using a macro. 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 > Just select the range of cells, hit Ctrl-F3, and add a name. > > >I want to create different ranges of cells to capture the content and > > duplicate on another sheet or workbook using a macro. 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" SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >I want to create different ranges of cells to capture the content and > duplicate on another sheet or workbook using a macro. 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. > or, select the cells and name in the NAME box to the left of the formula > box. [quoted text clipped - 4 lines] > >I want to create different ranges of cells to capture the content and > > duplicate on another sheet or workbook using a macro. If you want help with code, post it for comments. SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Thank you for the answer. How would I change a macro that I recorded to > use [quoted text clipped - 9 lines] >> >I want to create different ranges of cells to capture the content and >> > duplicate on another sheet or workbook using a macro. 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. > If you want help with code, post it for comments. > [quoted text clipped - 11 lines] > >> >I want to create different ranges of cells to capture the content and > >> > duplicate on another sheet or workbook using a macro. I wouldn't use ctr+c as it is already used by excel. Sub copyrangebyname() Range("character").Copy Range("g1") End Sub SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Here is the code I have now: > ub Character() [quoted text clipped - 30 lines] >> >> >I want to create different ranges of cells to capture the content and >> >> > duplicate on another sheet or workbook using a macro. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.