View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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