PDA

View Full Version : Solved: Number fill - randomly



vishwakarma
12-08-2010, 03:23 AM
Hello Guys,

I need a macro through which we can generate random numbers with in a range.

I need to fill the coloumn with numbers 1 to 90 randomly by clicking the button "Press" each time. Condition is that I don't need the numbers in one go and instead want one unique number at a time when ever I press the button(I need the unique number that is once a number is generated should not repeat again).

The number should be in sequence.Lastly,Each and evey time the button is pressed,the numbers should be highlighted


Thanks,

Bob Phillips
12-08-2010, 06:04 AM
Try this

vishwakarma
12-08-2010, 06:42 AM
This is just fantastic...:bow: Thanks a lot...


one more question, can we update the numbers on the selected active cells(where the curser is) within the range...is it possible...:think:

Bob Phillips
12-08-2010, 07:43 AM
You've lost me.

vishwakarma
12-08-2010, 09:27 PM
Sorry to create confusion, i was just asking if it is possible to update the values on the active cell (where the curser is) instead of updating anonymously.

But still thanks a lot for this great help...:hi:

I'm marking this thread a solved.

Bob Phillips
12-09-2010, 01:00 AM
That makes no sense to me. The numbers are allocated to specific cells, so if I am in the square for say 71, if I were to update the activecell, I can only insert 71. That is trivial code, and does not conform with the reuirement as I understand it.