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.
|