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

"Simon Lloyd " wrote in message
...
Hi all!

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

Simon


---
Message posted from http://www.ExcelForum.com/