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.

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.

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.

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.

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.

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.

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.