Guest User

Untitled

a guest
Dec 16th, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. Sub LowBidScore()
  2. On Error Resume Next
  3. Application.AutoCorrect.AutoFillFormulasInLists = False
  4. Dim nr(1)
  5. If nr(1) Then
  6. 'do nothing
  7. Else
  8. For j = 3 To 12
  9. nr(1) = ThisWorkbook.Sheets("BerekeningenEind").Range("Q" & j).Value
  10. For i = 2 To ThisWorkbook.Sheets("BerekeningenEind").Range("L" & j).Value + 2
  11. for k = 1 to ThisWorkbook.Sheets("BerekeningenEind").Range("L" & j).Value - 1
  12. Range(nr(1)).Offset(i, 2 * ThisWorkbook.Sheets("BerekeningenEind").Range("M" & j).Value + 2).Activate
  13. ActiveCell.FormulaR1C1 = "=MIN(RC[1]:R[5]C[1])/[@[ Inschrijfprijs]]*R[-1]C"
  14. Next k
  15. Next i
  16. Next j
  17. End If
  18. End Sub
Add Comment
Please, Sign In to add comment