Help needed selecting left cell same line

S

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
 
F

Frank Kabel

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

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
 
Top