I am trying to remove empty elements from a Collection. Here is the code I have so far.
Dim i As Integer
Dim Altered As New Collection
Altered.Add Range(Cells(12, 2), Cells(19, 12)).FormulaR1C1
For i = 1 To Altered.Count
If Altered.Item(i) = "" Then