Selection.End(xlToLeft).Select

[Norbert Jaeger]

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

[Norman Jones]

Hi Norbert,

Try:

ActiveCell.EntireRow.Cells(1).Select

Although it is rarely necessary to make selections.


---
Regards,
Norman



"Norbert Jaeger" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>