On the attached spreadsheet I created a simple Goal Seek macro to return a Profit Value (cell L5) by changing N5 to equal E5.
Please Login or Register to view this content.
What would code be to repeat this same caclulation for the various other rows in Column L?
Thank you.
PS very new to VBA so simplified explanation appreciated if possible.
Last edited by arlu1201; 08-09-2012 at 03:19 PM.
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. If you need more information on how to use them, check my signature. (In this post its a small code, but in future you may have bigger ones).
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]
Got it, thank you for the tip.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks