if you set an array to a range of cells, how to you fill it with only cells
that have text or a value in them?

arr2 = Worksheets("emp").Range("L2:L" & lastrow).Value

i only want cells that have text in them to populate the array

--


Gary