Random Numbers in a Range of Cells
0
I want to generate random numbers in my model. Every time I run the macro my cells range "G8:H34" have to fill in with different random numbers that should be integers from 0 to 2.
I have to generate those numbers in VBA, because I need to use them in order to optimize a model for a minimal costs and use loop after that to find the best combination that minimizes the cost.
Thank you!
vba code
asked Nov 8 '14 at 0:46
StudentStudent
1111
add a comment |
0
I want to generate random numbers in my model. Every time I run the macro my cells range "G8:H34" have to fill in with different random numbers that should be integers from 0 to 2.
I have to generate those numbers in VBA, because I need to use them in order to optimize a model for a minimal costs and use loop after that to find the best combination that minimizes the cost.
Thank you!
vba code
asked Nov 8 '14 at 0:46
StudentStudent
1111
4
Welcome to Super User. (0) What software are you running? Microsoft Office Excel? OpenOffice? LibreOffice? Lotus 123? Please edit your question and tag it with the relevant product. (1) Please phrase your question in the form of a question. Questions that have a question mark in them somewhere are better received than those that just read like a wish list. (2) We are not a script-writing service, and especially not a do-your-homework-for-you service. Please make an effort to solve your problem on your own. If you get stuck, come tell us what you’ve tried and where you’re having difficulties.
– G-Man
Nov 8 '14 at 1:10
So you are allowed to use =rand() or =randbetween(x,y) instead of VBA?
– Tyson
Nov 8 '14 at 2:20
add a comment |
0
0
0
I want to generate random numbers in my model. Every time I run the macro my cells range "G8:H34" have to fill in with different random numbers that should be integers from 0 to 2.
I have to generate those numbers in VBA, because I need to use them in order to optimize a model for a minimal costs and use loop after that to find the best combination that minimizes the cost.
Thank you!
vba code
asked Nov 8 '14 at 0:46
StudentStudent
1111
I want to generate random numbers in my model. Every time I run the macro my cells range "G8:H34" have to fill in with different random numbers that should be integers from 0 to 2.
I have to generate those numbers in VBA, because I need to use them in order to optimize a model for a minimal costs and use loop after that to find the best combination that minimizes the cost.
Thank you!
vba code
vba code
asked Nov 8 '14 at 0:46
StudentStudent
1111
asked Nov 8 '14 at 0:46
StudentStudent
1111
asked Nov 8 '14 at 0:46
StudentStudent
1111
asked Nov 8 '14 at 0:46
StudentStudent
1111
asked Nov 8 '14 at 0:46
StudentStudent
1111
1111
4
Welcome to Super User. (0) What software are you running? Microsoft Office Excel? OpenOffice? LibreOffice? Lotus 123? Please edit your question and tag it with the relevant product. (1) Please phrase your question in the form of a question. Questions that have a question mark in them somewhere are better received than those that just read like a wish list. (2) We are not a script-writing service, and especially not a do-your-homework-for-you service. Please make an effort to solve your problem on your own. If you get stuck, come tell us what you’ve tried and where you’re having difficulties.
– G-Man
Nov 8 '14 at 1:10
So you are allowed to use =rand() or =randbetween(x,y) instead of VBA?
– Tyson
Nov 8 '14 at 2:20
add a comment |
4
Welcome to Super User. (0) What software are you running? Microsoft Office Excel? OpenOffice? LibreOffice? Lotus 123? Please edit your question and tag it with the relevant product. (1) Please phrase your question in the form of a question. Questions that have a question mark in them somewhere are better received than those that just read like a wish list. (2) We are not a script-writing service, and especially not a do-your-homework-for-you service. Please make an effort to solve your problem on your own. If you get stuck, come tell us what you’ve tried and where you’re having difficulties.
– G-Man
Nov 8 '14 at 1:10
So you are allowed to use =rand() or =randbetween(x,y) instead of VBA?
– Tyson
Nov 8 '14 at 2:20
4
4
Welcome to Super User. (0) What software are you running? Microsoft Office Excel? OpenOffice? LibreOffice? Lotus 123? Please edit your question and tag it with the relevant product. (1) Please phrase your question in the form of a question. Questions that have a question mark in them somewhere are better received than those that just read like a wish list. (2) We are not a script-writing service, and especially not a do-your-homework-for-you service. Please make an effort to solve your problem on your own. If you get stuck, come tell us what you’ve tried and where you’re having difficulties.
– G-Man
Nov 8 '14 at 1:10
Welcome to Super User. (0) What software are you running? Microsoft Office Excel? OpenOffice? LibreOffice? Lotus 123? Please edit your question and tag it with the relevant product. (1) Please phrase your question in the form of a question. Questions that have a question mark in them somewhere are better received than those that just read like a wish list. (2) We are not a script-writing service, and especially not a do-your-homework-for-you service. Please make an effort to solve your problem on your own. If you get stuck, come tell us what you’ve tried and where you’re having difficulties.
– G-Man
Nov 8 '14 at 1:10
So you are allowed to use =rand() or =randbetween(x,y) instead of VBA?
– Tyson
Nov 8 '14 at 2:20
So you are allowed to use =rand() or =randbetween(x,y) instead of VBA?
– Tyson
Nov 8 '14 at 2:20
add a comment |
1 Answer
1
active
oldest
votes
0
Consider:
Sub qwerty()
Dim r As Range
Set r = Range("G8:H34")
With r
.Formula = "=randbetween(0,2)"
.Copy
.PasteSpecial (xlPasteValues)
End With
End Sub
answered Nov 9 '14 at 14:26
Gary's StudentGary's Student
13.9k31732
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f837421%2frandom-numbers-in-a-range-of-cells%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Consider:
Sub qwerty()
Dim r As Range
Set r = Range("G8:H34")
With r
.Formula = "=randbetween(0,2)"
.Copy
.PasteSpecial (xlPasteValues)
End With
End Sub
answered Nov 9 '14 at 14:26
Gary's StudentGary's Student
13.9k31732
add a comment |
0
Consider:
Sub qwerty()
Dim r As Range
Set r = Range("G8:H34")
With r
.Formula = "=randbetween(0,2)"
.Copy
.PasteSpecial (xlPasteValues)
End With
End Sub
answered Nov 9 '14 at 14:26
Gary's StudentGary's Student
13.9k31732
add a comment |
0
0
0
Consider:
Sub qwerty()
Dim r As Range
Set r = Range("G8:H34")
With r
.Formula = "=randbetween(0,2)"
.Copy
.PasteSpecial (xlPasteValues)
End With
End Sub
answered Nov 9 '14 at 14:26
Gary's StudentGary's Student
13.9k31732
Consider:
Sub qwerty()
Dim r As Range
Set r = Range("G8:H34")
With r
.Formula = "=randbetween(0,2)"
.Copy
.PasteSpecial (xlPasteValues)
End With
End Sub
answered Nov 9 '14 at 14:26
Gary's StudentGary's Student
13.9k31732
answered Nov 9 '14 at 14:26
Gary's StudentGary's Student
13.9k31732
answered Nov 9 '14 at 14:26
Gary's StudentGary's Student
13.9k31732
answered Nov 9 '14 at 14:26
Gary's StudentGary's Student
13.9k31732
13.9k31732
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f837421%2frandom-numbers-in-a-range-of-cells%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
4
Welcome to Super User. (0) What software are you running? Microsoft Office Excel? OpenOffice? LibreOffice? Lotus 123? Please edit your question and tag it with the relevant product. (1) Please phrase your question in the form of a question. Questions that have a question mark in them somewhere are better received than those that just read like a wish list. (2) We are not a script-writing service, and especially not a do-your-homework-for-you service. Please make an effort to solve your problem on your own. If you get stuck, come tell us what you’ve tried and where you’re having difficulties.
– G-Man
Nov 8 '14 at 1:10
So you are allowed to use =rand() or =randbetween(x,y) instead of VBA?
– Tyson
Nov 8 '14 at 2:20