instring

  1. J

    VBA Loop Speed - String Search and update

    Hello all, I need some help to improve my code. Right now I only have about 1700 lines to go through and the loop i created takes 5-10min. I must be doing something wrong or is there a way to speed up this code? Code searches one column per cell for specific word (2 options) then updates...
  2. P

    Searching in text without truncation

    I am looking for a way to search for words in text without truncating the search (which I automatically do if using instr). The script needs to be reasonably fast since I have about 3*50000 cells to search in and about 500 search terms. So far I have been using If InStr(UCase(title(j, 1))...
  3. J

    Instring Ucase Shorten Procedure

    I have the following macro to change a part of a cell if a value is found. i.e cell value (Help) maybe either of the following 3 examples Help, help, HELP Remember there is also text before and after the help value i.e. 123Helpabc My question is, can someone help with an abbreviated script...

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