I have a trigger cell which contains a value I am iterating between 0 and 170 degrees in 5 degree increments. As the value increases a number of different cells change throughout the spreadsheet which I want to paste to a table for each 5 degree increment. I have it working but I think there is a much more efficient way to do it. See code below:

Private Sub create_bombs_onstart() Dim re As Integer = 0 Dim r As Integer Dim zas As integer = 100 For f = 1 To t Step 1 r = Int(Rnd() * 100) + 1 If r <= zas Then isbomb(f) = True re += 1 Else isbomb(f) = False End If Next why aren’t all […]

Trying to avoid new signal when bar close if in the past 7 days I already have a valid signal.

I need the value of a cell in a for next loop. So far I have this:
‘Sub getcellvalue()
Dim Man_Rows As Integer
Man_Rows = Sheets(“Managers”).Cells(Rows.Count, “A”).End(xlUp).Row