Hello All,

In my program, I am trying to change the range names of the cells in column B to the values of each corresponding adjacent cell in column A, as well as precede the names with an underscore. I'd like to have it check if the name already matches up with the corresponding cell's value before it renames the range.

The problem is that I get an error on the first line of my if statement (run-time error 1004).
Any help is appreciated. Thanks in advance for your time.

Here is my code:

Please Login or Register  to view this content.