Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A1=A1+1...
Hi, i need a macro, that would add 1 to a number in cell ex. A1 when
for ex. B2 is greater then 0.50. I use RANDOM formula to generate number in B2. When generated number is greater then 0.50 then it should add 1 to cell A1. So when there is "27" in A1 and B2 generated 0.77 it should change A1 to 28, if not, it should leave it as A1 was. Can any one help me? Thanks, Martin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
A1=A1+1...
For looper = 1 To Range("B" & Rows.Count).End(xlUp).Row
Set cellPointer = Worksheets("Sheet1").Range("B" & looper) If cellPointer 0.5 Then cellPointer.Offset(0, -1) = cellPointer.Offset(0, -1) + 1 End If Next looper "Croc" wrote: Hi, i need a macro, that would add 1 to a number in cell ex. A1 when for ex. B2 is greater then 0.50. I use RANDOM formula to generate number in B2. When generated number is greater then 0.50 then it should add 1 to cell A1. So when there is "27" in A1 and B2 generated 0.77 it should change A1 to 28, if not, it should leave it as A1 was. Can any one help me? Thanks, Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|