Goal Seek VBA FOR/LOOP

The question is stated as:



You need to plot the series of x,y points that solve the equation
exp(x+y)=(x^2)/y - y^2
For the range of x values shown below. Set up the Excel worksheet to solve this problem using Goal Seek for each row. Write a VBA macro program that uses a FOR/NEXT loop that can be associated with the command button to solve the entire problem. You can use the extra columns if desired.

NOTE: The problem also has screen shot of excel looking like this:

[SOLVE FOR Y] <------Button
A.....B...C...D
4.....x....y
5.....1
6.....2
7.....3
8.....4
9.....5
10...6

Currently What I have is:



Option Explicit

Sub SolveFory()



dim x as double

dim y as double

size = range(B5:B10).cells.count



For B=1 To size

Range(B5:B10).cells(B)=0

Next B


End Sub





I know i'm missing the equation, but im not sure how to implement it. Also I'm not very good with VBA so im not really sure how much of what I already have is right. I could really use some help on this cause i don't understand it that well.



Thanks!

Brandon

bump bump bump