A macro to simulate CTRL+[

[kayard]

Hi, could anyone provide some code to simulate the behaviour of the shortcut CTRL+[ which select the precedents of currently active cell ?

Please note that the property activecell.directprecedents does not work when the precedent cell is in another sheet which is most often the reason why CTRL+[ is used (fast way to move between sheets)

Another way to obtain the same result would be to deselect "edit directly in cell " in the advanced options and then double click on the cell.

The reason why i need a macro is beacouse in the italian version of excel 2010 (only 2010) that shortcut doesn't work anymore (actually the italian version of that shortcut)

Thanks for any support

[mgaworecki]

Have you tried:

Application.SendKeys("^[")

HTH,
Mark


Sorry, I just re-read your post and noticed that you said the shortcut doesn't work anymore.

[kayard]

Hi, I found a solution:

Please Login or Register  to view this content.