I think if the cell  value is "seq(" & Seq_Number & ")" it will display all
that. I just want to display a number  (or later a letter buts lets not worry
about that). That is why I used a function. The way you have it, if
seq_number is 7 it will display "seq(7)". I just want it to display 7.

I cannot just overwrite it with 7 because then I will never find it again and
it would not update if another Seq was inserted  above it.

However, I might be able to combine the two.

If I use your method to make the formula  =seq(7),

And then have a function  which goes

Function seq(Parameter)
seq=parameter
End function

That should do it.

Now you know why I asked the question. I got valuable information.