Puzzling worksheet End

[AlexanderBB]

If I click cell A2 and then control-End it goes to row 892, for no apparent reason.
So I click row 892, move up to the top and shift-click row 2. Rows 2-892 are selected. Then Home-Clear All.
I don't include row1 as it has headings I want to keep, and is frozen.
But control-End in A2 still takes me to A892. Is this normal? And why 892?

 

[Peter_SSs]

So I click row 892, move up to the top and shift-click row 2. Rows 2-892 are selected. Then Home-Clear All.

After this, Save
Then try control-End in A2

 

[Peter_SSs]

Is this normal? And why 892?

Yes
Because at some stage you have had something (maybe only formatting) in row 892

 

[AlexanderBB]

Control-End still goes to 892 after Saving. I can also close and reopen Excel and it still goes to 892.
>Because at some stage you have had something (maybe only formatting) in row 892
Fair enough. But shouldn't it have cleared with Clear All?

 

[MARK858]

What does

=UNICODE(A892)

give you? in your 2019 version

 

[Peter_SSs]

Rows 2-892 are selected. Then Home-Clear All.

After selecting rows 2:892 instead of Clear All, what happens if you Delete the entire rows and then Save?

 

[AlexanderBB]

Thanks for the replies. @mark I'm not very familiar with Worksheet formula type things, I just use VBA. But I typed
=UNICODE(A892) into the formula bar and B3 (the cell highlit at the time) changed to #NAME?
@Peter, that was it. After that Control-End went to T1.
This fixed something else, I started getting an error and had to add Application.EnableCancelKey = xlDisabled
I'd asked about this in another thread here, but don't know how to link to it. Anyway my code now runs ok with that remmed out.
I suspect this caused it

Sub LastRowNum()
    RowNum = Cells.Find(What:="*", _
                    After:=Range("A1"), _
                    LookAt:=xlPart, _
                    LookIn:=xlFormulas, _
                    SearchOrder:=xlByRows, _
                    SearchDirection:=xlPrevious, _
                    MatchCase:=False).Row
End Sub

I may be wrong, but perhaps it'll happen again and I can prove it. An undetermined number of rows is being added and it was easier to use that to get the last used row, rather than keep track of the row as it was populated. At one time this returned a wrong number (yes in the 800s) and the next rows went there when they shouldn't have.

 

[MARK858]

=UNICODE(A892) into the formula bar and B3 (the cell highlit at the time) changed to #NAME?

Just for info you would get #NAME if you typed it in your 2010 version rather than your 2019 version as instructed

 

[Peter_SSs]

@Peter, that was it. After that Control-End went to T1.

Cheers. Thanks for the confirmation.

but don't know how to link to it.

I don't think we really need it but you would go to the other thread and copy what is in your browser's address bar and paste that here directly ..

why do I need Application.EnableCancelKey = xlDisabled

I've been working on something for several days when suddenly I get error Code execution has been interrupted Click debug and you can step through the code without any errors. After mucking around for ages including a widows reboot I Googled and found The solution for this problem is to add the...

www.mrexcel.com

.. or paste it in the 'URL' box after selecting the link icon above the reply window

and it will apear like this instead
why do I need Application.EnableCancelKey = xlDisabled

 

[AlexanderBB]

Thanks for that info...