Data dumping output from 'Find and Replace' box
Results 1 to 3 of 3

Thread: Data dumping output from 'Find and Replace' box
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data dumping output from 'Find and Replace' box

    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

  2. #2
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,133
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Data dumping output from 'Find and Replace' box

    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
    If you've posted a clearly explained question & sample data - both input & corresponding output - that can be copied to Excel, THANK YOU.
    Google can find answers to nearly every question.


  3. #3
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    9,133
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Data dumping output from 'Find and Replace' box

    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
    If you've posted a clearly explained question & sample data - both input & corresponding output - that can be copied to Excel, THANK YOU.
    Google can find answers to nearly every question.


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •