| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
End(x1Left) to column a
Anyone know how I can offset from the active cell to the leftmost column a.
I have been trying Selection.End(x1Left).Select but that doesn't work since I don't know how many columns to the left column a is each time. Sometimes it may be 65 columns to the left, othertimes just a few columns to the left. What command would you use? Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End(x1Left) to column a
i would just do something like this
myRow = ActiveCell.Row Cells(myRow, 1).Select -- -John Please rate when your question is answered to help us and others know what is helpful. "ORLANDO V" wrote: Anyone know how I can offset from the active cell to the leftmost column a. I have been trying Selection.End(x1Left).Select but that doesn't work since I don't know how many columns to the left column a is each time. Sometimes it may be 65 columns to the left, othertimes just a few columns to the left. What command would you use? Thank you. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End(x1Left) to column a
This worked great. Thank you.
"John Bundy" wrote: i would just do something like this myRow = ActiveCell.Row Cells(myRow, 1).Select -- -John Please rate when your question is answered to help us and others know what is helpful. "ORLANDO V" wrote: Anyone know how I can offset from the active cell to the leftmost column a. I have been trying Selection.End(x1Left).Select but that doesn't work since I don't know how many columns to the left column a is each time. Sometimes it may be 65 columns to the left, othertimes just a few columns to the left. What command would you use? Thank you. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End(x1Left) to column a
Try...
Cells(activecell.row, "A").Select -- HTH... Jim Thomlinson "ORLANDO V" wrote: Anyone know how I can offset from the active cell to the leftmost column a. I have been trying Selection.End(x1Left).Select but that doesn't work since I don't know how many columns to the left column a is each time. Sometimes it may be 65 columns to the left, othertimes just a few columns to the left. What command would you use? Thank you. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End(x1Left) to column a
This worked great. Thank you.
You made it look simple too ! "Jim Thomlinson" wrote: Try... Cells(activecell.row, "A").Select -- HTH... Jim Thomlinson "ORLANDO V" wrote: Anyone know how I can offset from the active cell to the leftmost column a. I have been trying Selection.End(x1Left).Select but that doesn't work since I don't know how many columns to the left column a is each time. Sometimes it may be 65 columns to the left, othertimes just a few columns to the left. What command would you use? Thank you. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End(x1Left) to column a
Hi
Selection.End(xlToLeft).Select will only work if all cells between column A and the selected cell contain a value. Use this instead CurrentRow = ActiveCell.Row Cells(CurrentRow, 1).Select Regards, Per "ORLANDO V" skrev i en meddelelse ... Anyone know how I can offset from the active cell to the leftmost column a. I have been trying Selection.End(x1Left).Select but that doesn't work since I don't know how many columns to the left column a is each time. Sometimes it may be 65 columns to the left, othertimes just a few columns to the left. What command would you use? Thank you. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
End(x1Left) to column a
Thank you. Worked great !
"Per Jessen" wrote: Hi Selection.End(xlToLeft).Select will only work if all cells between column A and the selected cell contain a value. Use this instead CurrentRow = ActiveCell.Row Cells(CurrentRow, 1).Select Regards, Per "ORLANDO V" skrev i en meddelelse ... Anyone know how I can offset from the active cell to the leftmost column a. I have been trying Selection.End(x1Left).Select but that doesn't work since I don't know how many columns to the left column a is each time. Sometimes it may be 65 columns to the left, othertimes just a few columns to the left. What command would you use? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| Search for a column based on the column header and then past data from it to another column in another workbook | Excel Programming | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C | Excel Programming | |||
![ORLANDO V[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
