The trouble with what you are asking is that you have to be able to get the VBA code to differentiate between a name and the other text you have in your cells. You will need to provide a fool proof method of doing this. Now you mentioned that the names are in blue, so we could use that to our advantage.
the following code relies on the name being BLUE as per the description when you hover over the coloured swatches. If this is not the colour of your text, then you will need to change this line
If Selection.Offset(X, 0).Font.ColorIndex = 5 Then
to the colorindex that refers to the colour of your names
Bookmarks