Sorry, I must have missed what was to be done with the results so just displayed them as they were being extracted in a message box in order to see the results.

You need to replace the MsgBox line with the cell address(s) you're wanting the result(s) to go in to.
For a more accurate/specific answer more information is required.
What's the sheet name? What column? All in one cell or ???