Advertisement
Guest User

Untitled

a guest
Dec 18th, 2014
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. Sub writeGroupData(ByRef groupData As Object, ByVal toSheetName As String)
  2. Dim i, line, valuesWithComma, host
  3.  
  4. ThisWorkbook.Sheets(toSheetName).Activate
  5. Cells.Clear
  6.  
  7. host = "test"
  8.  
  9. i = 1
  10. For Each groupName In groupData.Keys
  11. valuesWithComma = Join(groupData.Item(groupName).Keys, ",")
  12.  
  13. line = Join(Array( _
  14. "values:", valuesWithComma, "@", host & "." & groupName _
  15. ), " ")
  16.  
  17. Cells(i, 1).Value = line
  18. i = i + 1
  19. Next groupName
  20. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement