Hello,
I need help in a macro which allows me to generate 24 non-repeating numbers within a range that i will specify in vba, and than appear in selected cells.
For eg.
Range 1200 to 1300
Numbers to appear in cell A1:A4, B1:B4, and so forth
I tried finding all over the web but it only provides the ones where an input box will appear to specify the range i want when the macro is run.
Thanks in advance!
Hi ! Try this ‼
PHP Code:Sub Demo()
Dim Rg As Range
Randomize
With [A1:D6]
.Clear
For N% = 1 To .Count
Do
V% = Fix(Rnd * 101) + 1200
Set Rg = .Find(V)
If Rg Is Nothing Then .Cells(N).Value = V
Loop Until Rg Is Nothing
Next
End With
End Sub
Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !
Last edited by Marc L; 04-30-2015 at 01:16 PM.
Yeahhhh that's was what i was looking for! Thanks alot. Anyway if i want to change to range between 1300 to 1500, how do i do that?
Try this
Please Login or Register to view this content.
Thanks for your reply!
But is there anyway i can do it without the input box? Like key in the range straight in the code itself?
Then change inputboxes part to the numbers you want.
Don't really understand what you are trying to say though.
I meant like you specify the range of numbers within the code so that it will generate automatically instead of when I run the macro, an input box will pop up and i have to key in the range everytime.
But thanks anyway!
i.eOriginally Posted by jindon
Please Login or Register to view this content.
Oh alright! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks