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

F

Fantomas

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
 
M

Mungo

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

Fantomas

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
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top