Knight of Nee
Board Regular
- Joined
- Aug 4, 2003
- Messages
- 124
Hi.
Is there a way to rename a range of cells using a macro. however there is a twist i want the name to be the same as the contents of a cell. e.g if A1 = "Cat", then i want a range of cells to be called "cat", however if it equals "Dog" i want the range to be called "Dog".
Thanks for any help
Craig
Is there a way to rename a range of cells using a macro. however there is a twist i want the name to be the same as the contents of a cell. e.g if A1 = "Cat", then i want a range of cells to be called "cat", however if it equals "Dog" i want the range to be called "Dog".
Thanks for any help
Craig