Help needed selecting left cell same line

[Simon Lloyd]

Hi all!

Can anyone tell me how to get excel to select a cell in column A on th
same row that data has just been entered by a macro, but it has to ski
text in other cells to get there!....... selection.end(xltoleft).selec
wont work as it stops when it gets to a cell that contains data!

Simo

 

[Frank Kabel]

Hi
not quite sure what you're trying to do but try
msgbox cells(activecell.row,"A").value

 

[Norman Jones]

Hi Simon,

Try: cells(selection.row,1).select

 

[Jeff Standen]

If you're talking about the user doing it, then pressing the home key will
work. Otherwise:

Range("A" & ActiveCell.Row).Select

should do it.

Cheers,

Jeff