Right, I don't know if my title makes sense - I couldn't think of a better wording though!
Anyways, I'm working on a big fancy spreadsheet at the moment, and I've come across a useful bit of VBA for running a Goal Seek on mutiple cells, which after some testing and modification works well enough but for one issue, when the cancel button is clicked on any of the dialog boxes I get the following error;
"Runtime Error '424':
Object Required"
Now, I'm no VBA/VB guru by any means, so I've not really got a clue about this - what I'm looking for is a way to make it close gracefully - clicking cancel at any point means no data has been modified up to that point, so I need it to just end.
Is there some kind of function like -
That will do what I need, or am I being too simplistic?Code:OnError goto 'Exit' ...main code for Goal Seek... Sub Exit End End Sub
Cheers,
David


LinkBack URL
About LinkBacks
Reply With Quote
