ModManSEK
Aerospace
- Nov 20, 2000
- 21
I'm trying to write a VB Macro that will minimize (i.e., drive to zero) a column array of function values. There are about sixty values in the array. To date, I've been manually doing each array value using either "Goal Seek" or "Solver". This would be okay (time-consuming but manageable) if I only had to do it a few times. But I find myself constantly tweaking the spreadsheet which means that I must redo the functions over and over again.
Does anyone know how to accomplish this in Excel VB? I'm new to VB so I'm having trouble getting the VB syntax correct. I recorded the steps into a macro but I can't seem to get it to march through the array. Thanks in advance.
Does anyone know how to accomplish this in Excel VB? I'm new to VB so I'm having trouble getting the VB syntax correct. I recorded the steps into a macro but I can't seem to get it to march through the array. Thanks in advance.