Issue with blanks and spaces
Woops, I left this line in the code, which runs amok, delete it and click the Titles button to produce the list in column A
If Len(Trim$(Tlt)) 0 Then ActiveCell.Value = Tlt
For Each Tlt In aeRng
Range("A" & n).Resize(6).Value = .Transpose(.Index(Tlt.Resize(, 11), 0, Array(1, 3, 5, 7, 9, 11)))
If Len(Trim$(Tlt)) 0 Then ActiveCell.Value = Tlt
n = n + 6
Next Tlt
Howard
|