Relative Macro to Name a cell the contents of that cell.

Basically using the "record Macro" function with relative references on i select my first cell, hit "Define Name" and it defaults to the cell contents, then I hit Ok, move right to next column, rinse and repeat until my row is done.

The problem is, when I go to the next row to run the macro, it won't name the cells anything. I believe it is trying to name these cells the same names as the row above it. How do I get Excel to understand that I want the cells named by their contents?

Thanks!

Here is the Code the record macro function produced. I'm not Microsoft Visual Basic proficient, please help!

Please Login or Register  to view this content.