LinkBack URL
About LinkBacks
I hv 10x10 box (a1..j10) want to fill with random number 1-100
Any idea how to make function
Thanks b4
I hv 10x10 box (a1..j10) want to fill with random number 1-100
Any idea how to make function
Thanks b4
Last edited by VBA Noob; 12-24-2008 at 06:22 AM.
you could try:
=rand()
format the cells to suit
This link should get you started
I'd go with =randbetween , then you could put in the top and bottom numbers.
If you want random, non-repeating numbers from 1-100, you can use this function:
... and array-enter this formula in the 10x10 range:
Please Login or Register to view this content.
=RandSeq()
Entia non sunt multiplicanda sine necessitate
@all thanks..
Special to arthurbr for link, teach me array-enter and shg for the function..
Would you please mark the thread as Solved?
Click the Edit button on your first post in the thread
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
If more than two days have elapsed since your first post, ask a moderator to mark it.
Done, Thanks !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks