Hi All,
I accidentally named 2 different ranges the same name (i have 60 Team blocks, and naming then all Team1...Team60) - Unfortunately I named Team32, Team42 as well - so when i select either Team32 or Team42 it points to the same range - i have tried selecting the appropriate range for Team42 and calling it that but it jumps back to the range for Team32.
How can i clear them to start again?
Thanks,
I accidentally named 2 different ranges the same name (i have 60 Team blocks, and naming then all Team1...Team60) - Unfortunately I named Team32, Team42 as well - so when i select either Team32 or Team42 it points to the same range - i have tried selecting the appropriate range for Team42 and calling it that but it jumps back to the range for Team32.
How can i clear them to start again?
Thanks,