Talk About Network



Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Mac > Excel Office for Mac > Applescript, Ex...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 5561 of 5856
Post > Topic >>

Applescript, Excel & Sum a range

by distended@[EMAIL PROTECTED] Apr 30, 2008 at 03:18 PM

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

I am attempting to set the value of a cell at the end of a range to the
sum of the cells in that range.

The row location is a variable but the column is constant.

This is my lame attempt at the code:set value of cell d of column c to sum
of ranges (d of column 55) through (d of column 79)

When I compile this code the sum text color becomes green, indicating
applescript is assuming it is a variable and not a function.

Any help would be appreciated.

Thanks!




 3 Posts in Topic:
Applescript, Excel & Sum a range
distended@[EMAIL PROTECTE  2008-04-30 15:18:11 
Re: Applescript, Excel & Sum a range
distended@[EMAIL PROTECTE  2008-04-30 16:51:31 
Re:Applescript, Excel & Sum a range
"Theo Olsthoorn"  2008-06-08 02:11:50 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Jul 4 21:19:24 CDT 2008.