| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to edit Range Name
I have sheets in a workbook that have rows added each month. These
sheets have named ranges but, once the new data is added I need to expand the name ranges to include the new rows. I have been unsuccesful in writing a macro that can adjust the name ranges to include the new rows. The ranges are always row 1 through the last row in a specified column. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Record Macro and Edit Macro options disabled | New Users to Excel | |||
| allow users to edit range | Excel Discussion (Misc queries) | |||
| How do I edit a selected range then copy the range into an new sheet??? | Excel Programming | |||
| How to edit a named range | Excel Discussion (Misc queries) | |||
| Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
Threaded Mode
