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

Some videos you may like

This Week's Hot Topics

Top