Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that will insert names in an excel worksheet, the .
I need a macro that will insert names in an excel worksheet. The ranges
aren't always the same size. However they always start in column A and end in column U. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that will insert names in an excel worksheet, the .
Amazing what you find when you record a macro. Just modify to suit.
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 11/16/2004 by Don Guillett ' ' Range("C5:F11").Select ActiveWorkbook.Names.Add Name:="myname", RefersToR1C1:="=Sheet1!R5C3:R11C6" End Sub -- Don Guillett SalesAid Software "Ocicat" wrote in message ... I need a macro that will insert names in an excel worksheet. The ranges aren't always the same size. However they always start in column A and end in column U. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to create validation list of worksheet names | Excel Discussion (Misc queries) | |||
Need Macro to Collect Multiple Worksheet Names | Excel Worksheet Functions | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
Insert Worksheet Names into Cells | Excel Discussion (Misc queries) | |||
Macro to capture worksheet names | Excel Worksheet Functions |