Can someone explain why adding hyperlinks before adding validation switches from "," to ";" which is default xlListSeparator?
If I select range with 3 columns this will add dropdown list to column 2. However the list will be separated by ";" if hyperlinks are added before validation and if hyperlinks are added after validation the list will be separated by ",".
";" is default list separator for my language settings tho.
Code:
Sub test2() a = Join(Application.Transpose(Selection.Columns(1).Value2), "; ")
Selection.ClearHyperlinks
Selection.Validation.Delete
Selection.Hyperlinks.Add Anchor:=Selection.Columns(3), Address:="no address"
Selection.Columns(2).Validation.Add Type:=xlValidateList, Formula1:=a
End Sub
If I select range with 3 columns this will add dropdown list to column 2. However the list will be separated by ";" if hyperlinks are added before validation and if hyperlinks are added after validation the list will be separated by ",".
";" is default list separator for my language settings tho.