How do I define a range and run a simultaneous Goal Seek across the full range?
In other words, I am looking for a solution that does not run through all columns one-by-one, but rather all at the same time.
Kindly see attached spreadsheet (condensed version of a much more involved sheet otherwise).
I just signed up for the Commercial Services on this site. I really hope to resolve this
Last edited by avarax; 09-02-2013 at 10:48 AM.
Here is the code in use right now:
However, I would like the entire row to calculate all at once, simultaneously. If possible :-)
Please Login or Register to view this content.
Last edited by arlu1201; 09-03-2013 at 05:19 AM.
maybe all you need to do is stop all the selecting and screen updating.
Please Login or Register to view this content.
Avarax,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
ok, thanks arlu1201 for the hint, I will be glad to comply
Last edited by avarax; 09-03-2013 at 12:38 PM.
Thank you kindly, Andy. Clearly, I have much to learn still.... I ended up using my code based on what I could find and puzzled it together.....Originally Posted by Andy Pope
maybe all you need to do is stop all the selecting and screen updating.
Please Login or Register to view this content.
I wonder: What is the best way to truly learn VBA from scratch? I seem to only find bits and pieces scattered across forums but not a good way to start learning. I used to consider myself a fairly skillful Excel user, short of VBA though....
first you need an understanding of the syntax, then the application object mode, then real world problems.
A book is normally the best way to get a structured intro to the syntax and OM.
forums are great for real world problems.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks