Adjusting rows in sheet is messing up variables in rest of excel script

[johnnyL]

Unfortunately I am requesting a bit more help in learning Excel please.

I have Sheet2 set up as a table that I want to load values from.

I have 'declared', in the name box, names for each cell in sheet2. For example cell A5 is named 'CoinName1', cell A6 is named 'WebSite1', cell B5 is named 'CoinName2', cell B6 is named 'WebSite2'.

The problem I am encountering is when I manually 'cut/Insert cut cells' upwards/downwards to 'rearrange' the rows, the name box names also shift. I want the name box names to stay the same so that it doesn't mess up my other code.

For Example: If I 'cut/Insert cut cells' upwards from A6 to A5, I want cell A5 to still be named 'CoinName1' and cell A6 to still be named 'WebSite1', but as I have it now, cell A5 acquires the name of 'CoinName2' and cell A6 acquires the name of 'WebSite2'.

Is this easily fixable?

 

[JoeMo]

One of the advantages of using named ranges is that Excel keeps track of them when rows, columns, or cells are inserted or deleted. If your worksheet formulas, validation lists, ... employ the names, the formulas and lists are undisturbed by insertions and deletions. That's generally regarded as an advantage, not as a problem that needs to be fixed.

Maybe if you post your script and provide some more detail about what its intended to accomplish, someone can help you.