I'd suppose to renew all the task with a subroutine with changed fixed values :

Sub MultipTable()
Const NProb As Long = 10
Dim I As Long, J As Long, P(1 To 2) As String
For I = 1 To NProb
With Cells(I, 1)
For J = 1 To 2
.Formula = "=Randbetween(1,9)"
P(J) = CStr(.Value)
Next J
.Value = P(1) & " × " & P(2)
End With
Next I
End Sub

I hope not to spoil weekend for a lot of poor pupils.
--
Petr Bezucha


"CJ" wrote:

I have a multiplication table for a child to learn with. I don't want the
randomly generated questions to change value until after the child has
completed all of the questions.

"Mike H" wrote:

Hi,

You can turn calculation to manual but this of course affects all formula.
Aside from that there's not much you can do if your using RAND to get your
random numbers.

There are ways of getting non volatile random numbers and if you describe
what you want, someone will help.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"CJ" wrote:

Excel 2003. How can I switch from volatile to non-volatile? I don't want
randomly generated numbers to change every time the enter button is pushed or
a cell is modified. Thanks all.