Hi Folks:
First post and fast accepting a newb at Excel.
I am reading Mr Excel's VBA and Macros: Excel 2010 book.
In it, chapter 1, page 26, it says "Press End Key followed by the down-arrow key to move to the last row of the data".
This does not work with my keyboard. When I hit End Key (on 2 locations on keybaord, one being in the number pad to right), the cursor does not move, but I get a message in the lower left of the spreadsheet saying "End Mode", immediately to the left of the word "Ready".
However, when I hit CTRL-End, it moves me not to the bottom row, but to one column over and one row down from the last cell of data.
ie. If the last cell of data is D10, CTRL-End moves to to cell E11.
I am using a Logitech keyboard.
This is becoming a serious problem since I am taking a course in macro development, and my macros cannot be duplicated by the course instructor for grading.
Any ideas?
First post and fast accepting a newb at Excel.
I am reading Mr Excel's VBA and Macros: Excel 2010 book.
In it, chapter 1, page 26, it says "Press End Key followed by the down-arrow key to move to the last row of the data".
This does not work with my keyboard. When I hit End Key (on 2 locations on keybaord, one being in the number pad to right), the cursor does not move, but I get a message in the lower left of the spreadsheet saying "End Mode", immediately to the left of the word "Ready".
However, when I hit CTRL-End, it moves me not to the bottom row, but to one column over and one row down from the last cell of data.
ie. If the last cell of data is D10, CTRL-End moves to to cell E11.
I am using a Logitech keyboard.
This is becoming a serious problem since I am taking a course in macro development, and my macros cannot be duplicated by the course instructor for grading.
Any ideas?