![]() |
|
#1
|
|||
|
|||
|
Hello,
I need to write a mcro that fills all the cells in the block range of cell with random numbers between 0 and 1. so far I've done this: Sub number() Dim x As Double For x = 1 To 10 Workbooks("book1").Sheets("Sheet1").Range("A1:f20" ).Offset(x, j).Value = Rnd() Next End Sub the problem with my macro is having one random number on almost the entire determined range. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to fill a cell with random numbers to do calculations? | zanat0s | Excel | 1 | 06-13-2011 10:33 AM |
filling multiple cells whislt using Filter
|
VinceO | Excel | 1 | 05-09-2011 06:38 AM |
| Display Random Numbers as Transition | greenbutton | PowerPoint | 0 | 03-09-2011 04:43 PM |
Powerpoint loops, but not to beginning
|
imeister | PowerPoint | 1 | 02-02-2011 02:05 PM |
| loops within presentations | supateach | PowerPoint | 1 | 11-23-2010 04:42 AM |