Guest User

Untitled

a guest
May 22nd, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. Private Function data As Boolean
  2. Dim Avg_velocity As String
  3. Dim Avg_length As String
  4. Avg_velocity = Application.WorksheetFunction.Average(Sheets("Data").Range("K5:K650"))
  5. Avg_length = Application.WorksheetFunction.Average(Sheets("Data").Range("I7:I607"))
  6.  
  7. Sheets("Log").Range("A2:AI2").Insert
  8. Sheets("Log").Cells(2, "AA").value = Avg_velocity
  9. Sheets("Log").Cells(2, "AB").value = Avg_length
  10. End Function
Add Comment
Please, Sign In to add comment