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