Data dumping output from 'Find and Replace' box

[eddyble]

Should be an easy solution but i can't seem to figure it out.

Let's say you're looking for a specific word in a data set using the find and replace function and hit 'find all' - it displays all the results for the word you find.

All i want to do is copy the 'Cell' reference output and paste it somewhere. How does one do that?

Cheers

 

[Fazza]

this is good for me

CTRL-A
then in immediate window of VBE (ALT-F11, CTRL-G) ? selection.address
carriage return (that is, enter) to see the cell references

 

[Fazza]

I missed a step : after the CTRL-A you need to get out of the dialog box. Such as ESC or hitting the red close X on the top RHS

Another thought, instead of printing of addresses to the VBE immediate window you could print to a cell on the worksheet.
so instead of ? selection value
in the immediate window (change the A1 to whatever cell works for you) range("A1").value = selection.address