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

David C kirjoitti:
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



A code snippet you´re using would help to locate the problem.

Asko.

--

It is not necessary to understand things in order to argue about them.
Pierre Beaumarchais (1732 - 1799)