Data dumping output from 'Find and Replace' box

eddyble

New Member
Joined
Apr 30, 2018
Messages
4
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
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
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

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
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
 

Watch MrExcel Video

Forum statistics

Threads
1,102,452
Messages
5,486,991
Members
407,575
Latest member
calc

This Week's Hot Topics

Top