Private Sub ttttttt() Dim arr2() As String ReDim arr2(1 To 5) For i = 1 To 5 arr2(i) = "" & i Next For j = 1 To 5 Debug.Print arr2(j) Debug.Print WorksheetFunction.IsText(arr2(j)) Next End Sub
Private Sub ttttttt() Dim arr2() As String ReDim arr2(1 To 5) For i = 1 To 5 arr2(i) = "" & i Next For j = 1 To 5 Debug.Print arr2(j) Debug.Print WorksheetFunction.IsText(arr2(j)) Next End Sub