Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a Range name
Can anyone tell me how to insert a range name using code.
What I am tring to do is find a cell then activate that cell to call it by name for future use in my macro. here what I am tring. Cells.Find(What:="Cad Totals:", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate ActiveCell.Names.Add Name:="CadT" Cells.Find(What:="Totals in usd:", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate ActiveCell.Range("A1:D1").Select ActiveWorkbook.Names.Add Name:="USTotal" thanks Pete |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a Range name
ActiveCell.Name = "abc"
-- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert value based on range | Excel Worksheet Functions | |||
Auto insert a range | Excel Discussion (Misc queries) | |||
Insert...Name Range | Excel Discussion (Misc queries) | |||
insert row and range changes problem? | Excel Programming | |||
Insert SUM function for range | Excel Programming |