Hello.
I am trying to write some code that deletes a name from a range. then re-assigns that name to another.
More specifically.
A B C
1 2 3
2 2 7
6 7 8
9 8 2
The range of cells above would change each time another macro is run. There may be more or less rows of data. So it could be:
A B C
1 2 3
2 2 7
6 7 8
9 8 2
8 9 4
5 6 4
What i want to do is rename the range each time to account for the new rows.
I have been trying for hours. can anyone help me?
I am trying to write some code that deletes a name from a range. then re-assigns that name to another.
More specifically.
A B C
1 2 3
2 2 7
6 7 8
9 8 2
The range of cells above would change each time another macro is run. There may be more or less rows of data. So it could be:
A B C
1 2 3
2 2 7
6 7 8
9 8 2
8 9 4
5 6 4
What i want to do is rename the range each time to account for the new rows.
I have been trying for hours. can anyone help me?