Named Cell stayed put when I Cut and Paste the cell into another cell

[baileyisnotreal]

For context, I am a power user. Investment banker trained. My spreadsheets are highly detailed oriented, know all the keyboard shortcuts, yada yada yada. I say that so this doesn't get filed in the Newb folder.

My excel is acting weird lately. Recently in one of my companies excel pro forma templates (which I built) all of the reference cells in a P&L had moved down one row. e.g., what used to be =C101 was now C102. And this was for whole sections of the P&L. The only logical explanation I can think of for this is a I turned off formula calculation and then added a row in between them. But even that doesnt make sense and thats not an error I would make.

And now today, I just cut and pasted a bunch of Named cells e.g., Cell A1 is named "Term_Length" to a another set of cells (B1, ...) and all the values and formats were pasted, but the Named cell remained at the original Cell (A1). So A1 is now a blank, unformatted cell that is still named Term_Length and thus referenced by other cells, while the value of what should be in that cell (30) is in B1.

Am I going crazy? What do I do?

 

[My Aswer Is This]

For context, I am a power user. Investment banker trained. My spreadsheets are highly detailed oriented, know all the keyboard shortcuts, yada yada yada. I say that so this doesn't get filed in the Newb folder.

My excel is acting weird lately. Recently in one of my companies excel pro forma templates (which I built) all of the reference cells in a P&L had moved down one row. e.g., what used to be =C101 was now C102. And this was for whole sections of the P&L. The only logical explanation I can think of for this is a I turned off formula calculation and then added a row in between them. But even that doesnt make sense and thats not an error I would make.

And now today, I just cut and pasted a bunch of Named cells e.g., Cell A1 is named "Term_Length" to a another set of cells (B1, ...) and all the values and formats were pasted, but the Named cell remained at the original Cell (A1). So A1 is now a blank, unformatted cell that is still named Term_Length and thus referenced by other cells, while the value of what should be in that cell (30) is in B1.

Am I going crazy? What do I do?

You cannot do that.
A Named Range stays where it is no matter if you cut it and paste it into another range. You would need to go into Name Manager to change things.

 

[My Aswer Is This]

Or write you a script something like this:

Private Sub CommandButton1_Click()
Range("A1").Name = "George"
End Sub

This will change the Named Range

 

[Alex Blakenburg]

I don't agree with My Anser Is This.
If I cut and paste a cell with a Named Range (or a row) the name moves with the cell.
The only way I can get the named range to stay in place and the formula to move is with a sort. Is that a possibility ?

 

[My Aswer Is This]

I don't agree with My Anser Is This.
If I cut and paste a cell with a Named Range (or a row) the name moves with the cell.
The only way I can get the named range to stay in place and the formula to move is with a sort. Is that a possibility ?

I guess I copied the range it's true now that if i try cut the range name moves. Sorry