Goal Seek on Variable

[Atom]

When you create this macro:

Please Login or Register  to view this content.

This produces the compiler error "Invalid qualifier".

So how does one use a variable to perform a goal seek, or alternatively, use the difference between two cells?

[rorya]

GoalSeek is a range method, so you'd need a formula cell that subtracts the other two cells.

[Kaper]

The goal seek works on cell values. So if you have your ABS function in cell (say) A36 then you can perform

Please Login or Register  to view this content.

[MrShorty]

Goal Seek is just a fairly basic implementation of a Newton-Raphson or secant type algorithm. I have example code here (https://www.excelforum.com/tips-and-...ml#post4688682 ) that shows how to code a NR type algorithm in VBA. If you really want to do it all in VBA without using range.GoalSeek, then you should be able to look at what is in C36 and D36 and figure out how to execute an NR or secant algorithm on the formula(s) in C36 and D36.

[Sam1989]

I have a question that might be related to this.

I have this:

I'm wondering how I can set a max limit of 1.00 for PayRate?

I found references online that gave me two options but I was unable to implement them:

1- Set a static variable for your max value and then do an if check,

2- Create a function called checkMaxVal(int) that returns a bool.

Any help is appreciated!

[MrShorty]

@Sam1989: This forum is pretty strict about rules like not posting your question in another users thread. We strongly prefer that you start your own thread. If you are convinced that this thread will be of use, include a link or other reference to this thread in your new thread.