| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting needed format | Excel Discussion (Misc queries) | |||
| average line needed from one single cell | Charts and Charting in Excel | |||
| selecting every other line in excel | Excel Discussion (Misc queries) | |||
| How can I shift my data line to the left? | Charts and Charting in Excel | |||
| Selecting x cells to the left of the one you are on | Excel Programming | |||
![Simon Lloyd[_408_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
