Applescript Excel: How to move one cell to the right?

[Fant...@officeformac.com]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

I am desperately trying to move the active cell cursor
one cell to the right in Excel. There MUST be an easy solution
via Applescript but I cannot figure it out. Please help me
with the correct code to move the active cell position one cell
to the right!

Thank you

Fantomas

[Mu...@officeformac.com]

In Excel, go to Preferences, Edit and you can change there. You dont need Applescript!

[Fant...@officeformac.com]

> In Excel, go to Preferences, Edit and you can change there. You dont need Applescript!

Sorry, but this is no solution to my question.
I want to do the following thing with Applescript:

Lets say the active cell is "A1". Now I want Applescript to increase the
column to "B1", so that the "B1" is the active cell.
Please, could some of you help me to get the code for Applescript?

Thank you in advance

Fantomas

[TecNik]

Here are a couple of methods using AS:-

tell application "Microsoft Excel"
activate
select range "A1"
select (cell 6 of row 10 of active sheet)
end tell

[aol...@su.edu]

With VBA

Sub MoveSelectionUp()

Selection.Offset(-1, 0).Select

End Sub

Sub MoveSelectionDown()

Selection.Offset(1, 0).Select

End Sub


Sub MoveSelectionLeft()

Selection.Offset(0, -1).Select

End Sub

Sub MoveSelectionRight()

Selection.Offset(0, 1).Select

End Sub