after unmerge, select cell to the left when range unknown

[xcel_rider]

been trying but it's not working

Please Login or Register  to view this content.

[xcel_rider]

I tried different code i even tried sendkeys {left} it's not working all the code needs to do is move from selecting an unknown row and unknown number of colums starting at A to selecting A of that row (one cell)

[xcel_rider]

solution:
Selection.End(xlToLeft).Select

hopefully someone will find this useful