zzane
10-27-2009, 05:34 PM
In summary:
I have two options and two different solver inputs to run based on the options. I have got this working correctly.
One of the solver options produces 100 loops, while the second will produce less (say, 50)
The solver outputs are being graphed. If I use the first solver and then the second, I have data left over. This means my graph is using the 50 loops of my second solver option, and then the last 50 of the first solver options.I have googled around trying various combinations of what I'm looking for. After searching I found a formula posted by someone of this site, the VBA is (similar to), however, I could not find anything else suitable:
Option Explicit
Sub ClearCell()
Range("B103:B104").Clear
End Sub
My issues are that when I try to run the macro after implementing the above VBA is:
for "Option Explicit" - compile error: invalid inside procedure
If I remove it, VBA expects me to end the entire Sub I'm working on previous to opening this new one - i.e. the Sub I'm using for my entire macro
I'm relatively new to VBA and am not overly familiar with how Sub works, or what it actually does.
What I guess I'm really looking for is an answer as to whether or not it is possible to clear my 50 results before running the second conditional solving, or if I should implement a second button to clear the results for me (the easy way). It is preferred that it was all in the one click.
edit: I will have the macro clear all entries as solver sometimes returns no result. switching from one solver IF to another could produce anomalies in my graph.
I don't really want to post my VBA code to the public but can do upon PM request - this is for a University project and I don't particularly want someone else turning up with an identical VBA code :)
The gist of it goes like this:
sub starts,
IF decision,
loop starts - option one or option two,
loop ends,
sub endsWhat I want to have:
sub starts,
IF decision,
excess data is cleared,
loop starts - option one or option two,
loop ends,
sub endsAny insight would be much appreciated
I have two options and two different solver inputs to run based on the options. I have got this working correctly.
One of the solver options produces 100 loops, while the second will produce less (say, 50)
The solver outputs are being graphed. If I use the first solver and then the second, I have data left over. This means my graph is using the 50 loops of my second solver option, and then the last 50 of the first solver options.I have googled around trying various combinations of what I'm looking for. After searching I found a formula posted by someone of this site, the VBA is (similar to), however, I could not find anything else suitable:
Option Explicit
Sub ClearCell()
Range("B103:B104").Clear
End Sub
My issues are that when I try to run the macro after implementing the above VBA is:
for "Option Explicit" - compile error: invalid inside procedure
If I remove it, VBA expects me to end the entire Sub I'm working on previous to opening this new one - i.e. the Sub I'm using for my entire macro
I'm relatively new to VBA and am not overly familiar with how Sub works, or what it actually does.
What I guess I'm really looking for is an answer as to whether or not it is possible to clear my 50 results before running the second conditional solving, or if I should implement a second button to clear the results for me (the easy way). It is preferred that it was all in the one click.
edit: I will have the macro clear all entries as solver sometimes returns no result. switching from one solver IF to another could produce anomalies in my graph.
I don't really want to post my VBA code to the public but can do upon PM request - this is for a University project and I don't particularly want someone else turning up with an identical VBA code :)
The gist of it goes like this:
sub starts,
IF decision,
loop starts - option one or option two,
loop ends,
sub endsWhat I want to have:
sub starts,
IF decision,
excess data is cleared,
loop starts - option one or option two,
loop ends,
sub endsAny insight would be much appreciated