How to solve the refresh problem with the random question function

Since the characteristics of 20 numbers are not explained in the question, we will first set it to a positive integer within 100, and the statement of calculating the answer does not specify what kind of operation it is, but it is set to sum.

** As follows: sub ramsum().

dim rng as range

set rng = range("a1:a20")= "=int(rand()*100)"

rng =range("b1") =

set rng = nothing

end sub

Three workbooks in one table?

According to your statement, there should be three worksheets in a workbook, the random function will change, you can print one by one, print one copy, double-click a cell.

It can also be implemented directly using VBA.

I swiped it with a random function.,You must paste it selectively first.,Or the data will change if you don't open it.,It can be solved with VBA.。

You can do without the refresh button.

Use the shortcut key - F9 directly

Press it once and it will refresh once.

Ready-made buttons on the keyboard: F9. Can be used to refresh random data!

Press the F9 key to complete the data refresh.

Press once to refresh once.

Generally, we use the rand function when generating random trial data.

The rand function, also known as the random number function, results in a 0-1 decimal.

Call format: =rand().

Extension 1: If you want to generate an arbitrary range of numbers, you can do some operations and complete it.

For example, if a random number from 1 to 100 is generated, the call format is =rand()*100 extension 2:

The above one includes any value between 1 and 100. Normally, we use integers, so we need to use them with the integer function.

For example, =int(rand()*100) indicates that an integer from 1 to 100 is generated.

Do you require that these 5 numbers should be satisfied at the same time, and the addition of the previous one to the next one is not negative, and the subtraction is not negative? These two conditions cannot be met at the same time!

Because you require that there must be 2 negative numbers in these 5 numbers, when the subtraction is not negative, the two negative numbers must be next to each other (negative number - positive number = negative number) and on the last two digits, but then it will not be satisfied that the addition is not negative (negative number + negative number = negative number).

But if you want to satisfy that the addition is not negative, then the two negative numbers cannot be next to each other, but then the subtraction is not negative (negative - positive = negative).

So you can only meet these two conditions separately, and this can be achieved with a function or VBA.

This can be achieved with VBA programming.

Generate a random number with rnd().

Excel options --- formulas--- check "Auto Recalculation".

Dear, isn't there any requirement for random numbers? For example, between 20 and 80; Between; The decimal place is ...... 2 digitsIf you really don't ask for it, then whatever, d5 input: =rand()e5 input:

min($d$5:d5)+rand()*20-min($d$5:d5)), pull the formula to h5

Press f9 to refresh, it's all really random, and the maximum value will not be reduced to the minimum value by more than 20.

Use VBA. After generating a qualified random number, fill in the cell.

In excel2003, [Options] [Recalculate] changed "automatic recalculation" to "manual recalculation".

excel2010, similar.

Go give it a try!

Select all data area cells, right-click, copy, keep the selection unchanged, right-click, paste special, value, and you're good to go.

I guess I could only do what I said upstairs.