Why wont VBA recognise 'Find All' when recording a macro??

[bat18]

I am having problem with using 'find all' whilst recording a macro and hoping someone can guide me down the right path.

I am hoping to copy a cells contents, then in a different worksheet I want paste the contents of the into the find box (CTRL & f) then press find all.

Then I want to select all the cells that are listed in the find all box. When I close the box all the cells I want to find will remain highlighted (They will always be in the same column). I then copy the cells and paste them into a different worksheet.

When I look at the VBA for this, it simply misses out the part where I do the find all. It works absolutely fine for the 'find' and 'replace' function but doesn't seem to work for 'find all'.

Any help on this matter would be greatly appreciated

Thanks