View original (French)

Excel VBA select cell to the left

Solved
alec.po Posted messages 134 Status Member -  
 ya -
Hello,
I just need a little help on this point; I would like a VBA code to select the cell immediately to the left of the currently selected cell.

For example:
If B1 is selected, select A1
If D4 is selected, select C4
Thank you
Configuration: Windows Vista Firefox 2.0.0.13

1 answer

  1.
    alec.po Posted messages 134 Status Member 13
     
    It's good, I've found it:

    Selection.Offset(1, 0).Select
    6
    1. ya
       
      For a left shift, this macro is incorrect
      it would rather be:

      Selection.Offset(0, -1).Select
      0