View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ORLANDO V[_2_] ORLANDO V[_2_] is offline
external usenet poster
 
Posts: 37
Default 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.