Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub AllTransURL()
- Dim AT_rownum As Integer, pathrange As Range, AT_cellnum As String, sheetname As String
- sheetname = "All Transmissions"
- Set pathrange = ThisWorkbook.Worksheets("All Transmissions").Range("H1:H53")
- AT_rownum = Application.WorksheetFunction.Match("infra/remwip/Public/0_00_Rapports", pathrange, 0)
- AT_cellnum = Application.WorksheetFunction.Address(AT_rownum, 1, 1, 1, sheetname)
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement