Names can't have spaces in them.

Target.Offset(0,1).Resize(1,4).Name = Target
could be replaced (maybe???) with:
Target.Offset(0,1).Resize(1,4).Name = application.substitute(Target," ","_")

But there are other things that you could type that would also be invalid --
things that look like cell addresses for example.

mastermind wrote:

Well, that worked pretty well. The only problem is, is that when I
enter a topic like "Frontend Loaders" it produces an error. However,
if I highlight a set of cells and manually name them "Frontend_Loader"
everything is okay. What is causing this error, and how can I fix it?
Also will this work with "(" ")" in the topic cell?

--

Dave Peterson