partial search

  1. P

    Find a string within a wider string

    Source String: I have the string "5th Floor, Block-3," (note the comma after "Block-3"). List of Values: I have a list of addresses which contains the string "5th Floor, Block-3 " (note no comma after "Block-3", but there is a space after 'Block-3"). Required: Refer to screenshot image. I'm...
  2. P

    Search for file in userform and return directory and open pdf file

    Hi All, I have an urgent request. In a userform using Browsebutton, user will search for partial text in textbox then click browse. I would like this to open directory in " G: 'textbox.text'/ folder ", then user can open pdf/word/excel formatted files, in the applicable/relevant applications...
  3. I

    Find, xlWhole and xlPart as variables

    Good morning and happy Friday! Question: Is there a way to make xlPart and xlWhole variable? I do not know how to do that so i am attempting to do what you see below. I am running into an error with this code section below. Error 91: "Object variable or With block variable not set"...

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