Apple

On Jul 21, 2012, at 5:15 PM, Christian Boyce wrote:

This works for me:

tell application "Microsoft Excel"
set the_cell to selection
set x to first row index of the_cell
set formula of the_cell to "=D" & x & "-G" & x & "-H" & x
end tell

On Jul 21, 2012, at 9:29 AM, Bill Guion wrote:

I have an Excel spreadsheet that I use to keep track of medical expenses, insurance payments, my payments, etc. On some rows, in the ith column, I enter this formula: =D9-G9-H9 (if the entry happens to be in row 9). What I normally do is move the active cell to another row, copy the formula, move the active cell back, and paste the formula.

It would be nice to activate the desired cell and enter a key combination which would run an Applescript. The Applescript would determine which row is active and construct the formula (let x be the active row): =Dx-Gx-Hx, then paste the formula in the active cell.

Can someone point me in the right direction for this?

-----===== Bill =====-----

References:
	>Excel Question (From: Bill Guion <email@hidden>)
	>Re: Excel Question (From: Christian Boyce <email@hidden>)