find.spec

  1. A

    Dynamic Cell Row and choose certain columns to Paste into a diff. ws or wb

    I am searching for data which I just entered via INPUTBOX. Searches for Data within Range(G7 and CA10000) If the data is found then it copies that cellrow and range of Columns H thru K and Column S and Columns AC thru BZ into a diff. Worksheet or Workbook (Haven't Decided). If this data...
  2. H

    VBA InStr - recognize code format ##.##.#### - no character

    Hi All, In VBA I need to have a code which shows a number with the following format: ##.##.#### This must replace the Find.Spec formula, which is not available in VBA and I can not get the InStr function working with wildcards. See example of the current status below. I now have the...

This Week's Hot Topics

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
Top