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

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

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

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