| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection.End(xlToLeft).Select
Selection.End(xlToLeft).Select
which command will move the cursor to column A, independent of blank cells or cells inclusive entries? Not each cell in a row does have an entry. So once the active cell is M5 and there are entries up to C5 (B5 is blank). The cursor will only jump to C5 with above mentioned command. Regards, Norbertx |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection.End(xlToLeft).Select
Hi Norbert,
Try: ActiveCell.EntireRow.Cells(1).Select Although it is rarely necessary to make selections. --- Regards, Norman "Norbert Jaeger" wrote in message ... Selection.End(xlToLeft).Select which command will move the cursor to column A, independent of blank cells or cells inclusive entries? Not each cell in a row does have an entry. So once the active cell is M5 and there are entries up to C5 (B5 is blank). The cursor will only jump to C5 with above mentioned command. Regards, Norbertx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SELECT DUPLICATE IN SELECTION | Excel Worksheet Functions | |||
| Select last cell in Selection | Excel Discussion (Misc queries) | |||
| I do not see the selection colour when I select some cells | Excel Discussion (Misc queries) | |||
| Why doesn't Selection.End(xlDown).Select always work? | Excel Programming | |||
| Loop too slow deleteing xltoleft | Excel Programming | |||
Hybrid Mode
