Apple script

[Erin23]

Hi guys,

I need help with using apple script and excel. I have an excel sheet in which im using goal seek but the problem is that i have up to 60 items to goal seek. I know using apple script would be faster than doing it individually. I have written this code so far but it dosen't seem to work and i was wondering what the problem is and how can I tell apple script to do it 60 times. Thanks

goalseek (range "Totalvolume" of worksheet "fracture design1)" goal range "F18"
changing cell (range "fracture length (ft)" of worksheet "fracture design1")

[tedsmith3rd]

Can you attach an example of the type of spreadsheet you're referring to? Instead of using applescript can you make this work with excel formulas and maybe filling down/up/whatever? Which version of excel are you using?