Help needed selecting left cell same line
 

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

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

Help needed selecting left cell same line
 

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

-----Original 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/

.

Help needed selecting left cell same line
 

Hi Simon,

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

---
Regards,
Norman

"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/

Help needed selecting left cell same line
 

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/