Advertisement
Guest User

Untitled

a guest
Jun 27th, 2013
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. Sub mojemakro()
  2. krok = 0.001
  3.  
  4. For i = 1 To 20
  5. Range("C94").FormulaR1C1 = i * krok
  6. Cells(1 + i, 55).Value = i * krok
  7.  
  8. Range("V97").Copy
  9. Cells(i, 56).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
  10. :=False, Transpose:=False
  11.  
  12. Range("X97").Copy
  13. Cells(i, 57).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
  14. :=False, Transpose:=False
  15. Next i
  16. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement