Hey Everyone,
I have a function that assigns the each range a name based on the header.
That works.
However, I would like to inform users when the headers aren't valid for named range, and then explain to them why. I know that a runtime error does the same, but people get freaked out by errors.
I want to let the user know if a) the contents of the header have a space in them, b) the header starts with a number c) there is an empty header d) it includes a comma. Thus far I am trying the following but getting caught up in several places.
If I could get some help with this I would be immensely grateful.
Bookmarks