I am trying to transpose an array () as String using the Transpose function.
Application.WorksheetFunction.Transpose (DataArray)
This does not seem to be working as Debug.Print Ubound(DateArray,1) and Debug.Print Ubound(DateArray,2) before and after the transpose statement provide the same values indicating that the rows and columns have not been switched as as result of the transpose.
Does transpose not work on string arrays? And if so, do I need to convert the string array to a variant array? If so, how do I do that
Regards
RK
Application.WorksheetFunction.Transpose (DataArray)
This does not seem to be working as Debug.Print Ubound(DateArray,1) and Debug.Print Ubound(DateArray,2) before and after the transpose statement provide the same values indicating that the rows and columns have not been switched as as result of the transpose.
Does transpose not work on string arrays? And if so, do I need to convert the string array to a variant array? If so, how do I do that
Regards
RK