It is not in sequence but more like a combination of sequences. Can it be done with less code?
Update: I forgot to add that the numbers must be produced by a macro. I'm not sure how it is written though.
1 answer 1
Are you sure you want to delete this answer?
Sorry, something has gone wrong.
Best Answer: YOur formula is missing a Function. Can you describe your excel sheet and perhaps we can get closer to what you may need.
Update to add:
What I mean is, what cells have what information and how does it all pertain to eachother? For example, the first A in your sample above refers to a column, not any particular cell. Being in parenthesis means it's some sort of excel formula, but has no function. As an example =SUM(a1+B1) would give you the total of adding the number in cell A1 to the number in cell B1. So, more info would help....
Edit to add
You don't need a macro, you can do this with a function RANDBETWEEN Read more here https://exceljet.net/excel-functions/exc...
As an example, you would put the FORMULA
=RANDBETWEEN(lowest,highest) in cell A1
then each of the cells across the row would do your math for you.
B1 would be =A1+5
C1 would be =A1+10
D1 would be =A1+15
does this do what you needed?