Goal Seek Macro

[Greg Determann]

I am just getting my feet wet in VBA and have a question.

I am trying to figure out how to write a macro that will look at cell C3 and C4 and determine which one is lower. If c3 is lower, then set it to a value of 0 by changing cell c2 and then move onto the next column. Eventually, the number in row 4 will be smaler than the row 3 value. At that pt I need it to goal seek to set the row 4 number to zero by still changing the corresponding row 2 value. After that, it is finished. Any ideas?

 

[erik.van.geit]

Greg,

just getting your feet wet?
then take it step by step

let's first try to compare two cells
my question to you : can c3 = c4 ?

Sub Macro1()
If Range("C3") < Range("C4") Then MsgBox Range("C3") & " < " & Range("C4")
End Sub

can you make this work?
try then to make some variations on this theme...

kind regards,
Erik

 

[Greg Determann]

I got it to work - I was making it way too complicated. Thanks for all your help.

Greg

 

[erik.van.geit]

Fine, Greg,

Perhaps some people were busy to help you or others will come back for the solution. So please post how you solved this.

kind regards,
Erik