Thread: End(x1Left) to column a
View Single Post
  #1   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
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 With QuoteReply With Quote