Selection.End(xlToLeft).Select

N

Norman Jones

Hi Norbert,

Try:

ActiveCell.EntireRow.Cells(1).Select

Although it is rarely necessary to make selections.
 
N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top