Guest User

Untitled

a guest
Jan 15th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. r = mainWS.Cells(count, 1).Value
  2. paths = mainWS.Cells(i, 2).Value
  3. pathd = mainWS.Cells(i, 6).Value
  4.  
  5. .....
  6.  
  7. If (r = "H") Then
  8.  
  9. Application.Workbooks.Open (pathd & "" & filed)
  10. Set dWB = Application.Workbooks(filed)
  11. Set tabD_WB = dWB.Sheets(tabd & "")
  12.  
  13. Application.Workbooks.Open (paths & "" & files)
  14. Set sWB = Application.Workbooks(files)
  15. Set tabS_WB = sWB.Sheets(tabs & "")
  16.  
  17. End If
  18.  
  19. Set uRange = tabD_WB.Range(Cells(1, 1), Cells(5, tabD_WB.UsedRange.Columns.count))
  20.  
  21. Application.Workbooks.Open (pathd & "" & filed)
  22. Set dWB = Application.Workbooks(filed)
  23. Set tabD_WB = dWB.Sheets(tabd & "")
  24.  
  25. Set dWB = Application.Workbooks.Open(pathd & "" & filed)
  26. Set tabD_WB = dWB.Sheets(tabd)
  27.  
  28. With tabD_WB
  29. Set uRange = .Range(.Cells(1, 1), .Cells(5, .UsedRange.Columns.Count))
  30. End With
Add Comment
Please, Sign In to add comment