Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define name in macro
I need to define a named range in a macro. The define name is not the
problem though. The sheet I'm using gets updated daily and varies as to the number of rows. I need the macro to find the last record in the table and reset the named range to include all data. I've tried and nothing I do seems to work. Any suggestions would be helpful. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define name in macro
Instead of using a macro, use a dynamic range that you can define once
and it self-corrects for additions and deletions: http://cpearson.com/excel/excelF.htm#DynamicRanges In article , "Walleye Hunter" wrote: I need to define a named range in a macro. The define name is not the problem though. The sheet I'm using gets updated daily and varies as to the number of rows. I need the macro to find the last record in the table and reset the named range to include all data. I've tried and nothing I do seems to work. Any suggestions would be helpful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to define decimal places in macro? | Excel Discussion (Misc queries) | |||
define max in range (macro) | Excel Discussion (Misc queries) | |||
Macro - define cell range for a sum function | Excel Discussion (Misc queries) | |||
Macro to Define Range Name | Excel Programming | |||
using a macro to define the contents of a cell as the save as name | Excel Programming |