Creating a goal seek function

First of all, thank you for taking time to help me out. I have very little experience with coding so thanks for being patient.

My problem is trying to figure out a friction coefficient and to do it repeatably in a mass of data.

The friction coefficient is in both sides of a formula (LHS and RHS) so I'm using a goal seek to set the delta (LHS-RHS) to zero.

I have 4 columns I'm working with: LHS, RHS, Delta, FricCoeff

I would like to create a function that I can type into the formula and drag all the way down to the end of the chart in the FricCoeff column. For example, I would like to enter in "=goalseek(delta)" where I choose the cell 'delta' is in. So it would appear something like =goalseek(c2) or something.

I believe I have to set the friction coefficient column to some value first before goal seek works so I've set it to "1". This is what I have in code, but I know for a fact that this doesn't work and is probably wrong on so many levels in terms of syntax...so sorry for that..

Please Login or Register  to view this content.

Any help would be great!
Thank you again

Welcome to the forum.

A user-defined function can't do anything but return a value to the cell in which it appears, so it needs to be a sub.

Please Login or Register  to view this content.

Please take a few minutes to read the forum rules, and then edit your post to change your QUOTE tags to CODE tags.

Thanks.

Thanks.

I don't have a clue how to answer those questions without seeing what you're trying to do. Can you post a workbook and explain in context?