Apple

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>)