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?
|