Hi

How do i call the following code, but not get back any empty cells

Set tempRange = Worksheets("Step Chart").Range("ColumnMapping")

As it returns all the cells, even if they are blank/empty...

I can return just the empty cells by using
..SpecialCells(xlCellTypeBlanks)
What is the reverse of this?

As in the end i want an array without any empty values, if there is any
in the named range.