ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selection.End(xlToLeft).Select (https://www.excelbanter.com/excel-programming/337125-selection-end-xltoleft-select.html)

Norman Jones

Selection.End(xlToLeft).Select
 
Hi Norbert,

Try:

ActiveCell.EntireRow.Cells(1).Select

Although it is rarely necessary to make selections.


---
Regards,
Norman



"Norbert Jaeger" wrote in message
...
Selection.End(xlToLeft).Select

which command will move the cursor to column A, independent of blank
cells or cells inclusive entries?

Not each cell in a row does have an entry. So once the active cell is
M5 and there are entries up to C5 (B5 is blank). The cursor will only
jump to C5 with above mentioned command.

Regards,

Norbertx





Norbert Jaeger

Selection.End(xlToLeft).Select
 
Selection.End(xlToLeft).Select

which command will move the cursor to column A, independent of blank
cells or cells inclusive entries?

Not each cell in a row does have an entry. So once the active cell is
M5 and there are entries up to C5 (B5 is blank). The cursor will only
jump to C5 with above mentioned command.

Regards,

Norbertx




All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com