So, im trying to make a function that updates automatically whenever i change manually the value of a cell. It should work like this:The MAX value defines the max value of this list

and whenever i change it, the list changes too

I could do it with a Sub Process, but it only updates manually. So i thought i could just make it a function and use it in a random cell and it would update automatically, but it didn’t work:

Function lista_auto(n)

For i = 2 To n
Range(“E” & i) = i – 1

listaauto = Null

End Function

Error

Does anyone have a solution to this? Or is it just impossible?