Is it possible to make a macro that will Set Goal Seek on the current cell, with the Changing Cell as the cell directly to the right, and Goal on the cell directly to the left of the selected cell?
Thanks
EDIT:
Attached template
Is it possible to make a macro that will Set Goal Seek on the current cell, with the Changing Cell as the cell directly to the right, and Goal on the cell directly to the left of the selected cell?
Thanks
EDIT:
Attached template
Last edited by Test123Test; 06-18-2012 at 07:30 AM.
Hi.
attach a template file
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
![]()
Sub GS() If TypeOf Selection Is Range Then With Selection.Cells(1) .GoalSeek Goal:=.Offset(, -1), _ ChangingCell:=.Offset(, 1) End With End If End Sub
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks