So I was wondering if anyone knows how I could send the solution Goal Seek finds to a cell other than the dynamic variable cell (the "changing cell") preferably without even changing the variable cell.

Here's a very simple goal seek macro:

Sub Test()
Range("A6").GoalSeek Goal:=50, ChangingCell:=Range("A3")
End Sub


I want the solution to be sent to, say, cell B3 preferably without even changing A3 at all


Is this possible?


Thanks in advance