Hi,
What i want to do is check the contents of a cell to make sure it can be a valid range name and not clash with a posible cel ref. Ie
Name should be longer than 2 characters so it won't clash with a cell ref "C1" or a column ref "GI"
also is it possible to check for refences like "CB4" or "IV65536" incase of larger spead sheets?
cheers in advance
J
What i want to do is check the contents of a cell to make sure it can be a valid range name and not clash with a posible cel ref. Ie
Name should be longer than 2 characters so it won't clash with a cell ref "C1" or a column ref "GI"
also is it possible to check for refences like "CB4" or "IV65536" incase of larger spead sheets?
cheers in advance
J