Wrong End

[Genlist]

Have spreadsheet with over 14,000 rows and when using "Selection.End(xlDown).Select" the cursor stops at row 12,106 not matter which column I test. Why does it stop on that row instead of 14,054?

 

[Genlist]

Norie, response of yesterday 11:45 is reffering to your code.

 

[Norie]

That wasn't very clear, to me anyway.

The code I posted will always start at the bottom and go up.

What are you trying to do anyway?

 

[Genlist]

Norie, What I am trying to do is go to the end of the data at row 14,054. Starting at A1 using the my code in my first thread the cursor stops at row 12,106 instead of the last row 14,054 I've tried changing columns on row 1 and the cursor still stops on row 12,106. On a blank column the cursor goes to row 1,048,576.
With your code;
Starting at the bottom, row 1,048,576 the cursor moves up to the last row of data, 14,054.
Starting at a blank column at row 1,048,576 the cursor moves to row 1 of that column.
Starting at the bottom of the data, row 14,054 the cursor does not move.
Starting at the row below, 14,055 (blank cell) the cursor moves 1 row up to 14,054.
Starting at A1 the cursor moves to the last row of data, 12,106. I know it's suppose to move up but it moves down. That is crazy.

By the way thanks to everyone that has assisted with the thread

 

[Norie]

I thought that's what you wanted and I see you have a solution.