This code was working fine.
But then we moved to Excel 2013....
Why would this give an SUBSCRIPT OUT OF RANGE error?
But then we moved to Excel 2013....
Why would this give an SUBSCRIPT OUT OF RANGE error?
Code:
For L = 10 To LastRow
myDebNr = Worksheets(daWsheet).Range("A" & L).Value
Worksheets(daWsheet).Range("A" & L).Hyperlinks(1).Address = "SomeURL"
Next