find all

  1. B

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

    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...
  2. E

    Find Insert Multiple Occurences

    I need help with an Excel Macro. I need to find each occurence of 24 different TEXTs and next to each insert cells to add additional information. The number of occurences of each text varies and may appear in the range of K2:IV2000, so there may be for example 14 occurences of TEXT1 and then 35...
  3. J

    Another Thread extraction question!

    I want a formula that will take a filepath reference and yield only the filename, for example: Cell A1 contains: <TABLE style="WIDTH: 402pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=536 x:str><COLGROUP><COL style="WIDTH: 402pt; mso-width-source: userset...
  4. B

    Find reference errors and delete

    Hello, As a beginner I am having a tough time writing out some VBA. I am attempting to write out a macro that will find all reference errors within a range, select those cells along with the cell immediately adjacent to the left, and delete them (shifting cells upward). Can anyone help?
  5. D

    How to export "Find All" to a file

    Good afternoon, I've used the search function on here and haver been unable to locate an answer for my question, so I thought I'd throw it out there. I am using the Excel feature of Find to locate a sheet reference in formulas throughout a 12 page workbook. It returns 148 instances of the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top