| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I don't want to repeat the same number
how can I change a repeating number?
this is what I have so far. Thank you! Private Sub Worksheet_SelectionChange(ByVal Target As Range) A = Cells(1, 1) + 2 Dim Rw, Col Rw = Target.Row: Col = Target.Column If Col < 2 Then Exit Sub If Rw < 3 Or Rw A Then Exit Sub If Cells(Rw, Col) = Cells(Rw, Col) Then Cells(Rw, Col) = Int((A * Rnd) + 1) Else: Exit Sub End If End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| repeat number multiple times | Excel Discussion (Misc queries) | |||
| Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
| repeat a formula same column same number of rows apart | Excel Discussion (Misc queries) | |||
| Repeat statements "x" number of times... | Excel Discussion (Misc queries) | |||
| how do I get a calculation to repeat various number of times? | Excel Worksheet Functions | |||
Threaded Mode
