I have a worksheet which i need to gather a string from. It consists of
multiple rows of data containing strings which i need to search and pull the
cell reference from the string i am searching and store this into an array
and print the list into a new sheet?

I have managed to get the cell range into an array but it contains all cell
strings and empty cells. Any help or pointers in the right direction would be
appreciated. I have my head in a book but am still racking my brain for a
solution