Macro to Scroll to Named Row

[Neuner]

I'm using ActiveWindow.ScrollRow = 3 in a macro to take me to the top of a long list of data.

The list of data is always changing so I've named the last row "BorderLastRow". Can ActiveWindow.ScrollRow be used to take me to the bottom of the list?

There is additional information below "BorderLastRow" that I don't want to see so Ctrl+End has not been the best solution.

Thank you!

 

[Fluff]

How about

ActiveWindow.ScrollRow = Range("BorderLastRow").Row

 

[Neuner]

Thank you Fluff but that still takes me to the top of the page for some reason.

 

[Fluff]

Is "BorderLastRow" a named range? or just the value in a cell?

 

[Neuner]

Is "BorderLastRow" a named range? or just the value in a cell?

It's a named Row. Guess that constitutes as a range? If you click on the row number on the left and highlight the entire row, the name BorderLastRow appears.

 

[Fluff]

In that case with the code I supplied the sheet should scroll so that row is at the top of the window.
Is it not doing that?

 

[Neuner]

Okay, it is working now. Not sure what was wrong. I shut down excel and re-opened the file and it is good to go. Thank you!!

 

[Fluff]

You're welcome & thanks for the feedback

 

[Neuner]

I would appreciate it if you would take a look at this other thread of mine? https://www.mrexcel.com/forum/excel-questions/1085128-macro-copy-cells-clipboard-if.html