Macro - Dynamic Copy Range

[Lacaycer]

I can't wrap my head around how to write the if statement required to copy a selection of cells if a name exists in the them.

I have a column (T) where the output of a cross reference is either a name or "#NUM!", the names will always be sequential at the top of the column. I need all names to be selected. - This is the part I'm having trouble with.

Once copied it's simply paste values to the first open cell in "F" column of the "EmployeeStatusList" range.

I have other steps required to complete this macro, but as long as I get the code to select the names I can do the rest.

In summary - Select cells from T1 - T50 if contents is other than #NUM! or ""....also in the event that there are no cells the whole process stops,copy nothing.

Thanks