Is it possible to create this type of function ?

Hi I'm a french engineering student (my english may not be verry good/I hope you will understand : ) ), for my main project I need to create an algorithm and I don't know if it is possible on excel. ...

excel

Formulas and Functions

Macros and VBA

JKPieterse
Jan 25, 2024
victor_barth Have you tried Goal seek? Otherwise a very simple macro would do.
Sub SolveFor() Dim ct As Long Do ct = ct + 1 Range("A2").Value = ct Loop until Range("A12").Value End Sub

JKPieterse

Silver Contributor

Jan 25, 2024

victor_barth Have you tried Goal seek? Otherwise a very simple macro would do.

Sub SolveFor()
Dim ct As Long
Do
    ct = ct + 1
    Range("A2").Value = ct
Loop until Range("A12").Value
End Sub

victor_barth
Copper Contributor
Jan 25, 2024
It works perfectly as I imagine it
Thanks a lot!

Forum Discussion

Is it possible to create this type of function ?