| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a macro to set a range name in EXCEL
I cannot figure out how to define a range name with a
macro. The range is variable |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using a macro to set a range name in EXCEL
Range(Cells(1,1),Cells(1,1).End(xldown)).Name = "RangeName"
-- Regards, Tom Ogilvy Eric Tepen wrote in message ... I cannot figure out how to define a range name with a macro. The range is variable |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using a macro to set a range name in EXCEL
Eric,
A simple way to name a range would be: range("A1:C5").Name = "TestRange" The range is variable In what way??? Rows? Columns? There are a lot of variations on the above. Post back with more info and someone will be sure to help you out. John "Eric Tepen" wrote in message ... I cannot figure out how to define a range name with a macro. The range is variable |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help writing Excel macro when range changes | Excel Worksheet Functions | |||
| macro to copy from excel range to word doc | Excel Discussion (Misc queries) | |||
| Help with Dynamically changing Range in Excel Macro | Excel Discussion (Misc queries) | |||
| How do I set up a formula with a changing range in an excel macro | Excel Discussion (Misc queries) | |||
| Macro to copy range from Excel files in folder | Excel Discussion (Misc queries) | |||
Hybrid Mode
