Search Function

[itsme2]

I have a bit of code, modified from the board, that will search a specified spreadsheet, and return the located information (row), and copy it to another row on a "results" worksheet.

I use 2003 Excel and XP. On the laptops at work they run 2K Pro and Excel 2003.

On the work laptop, if the "case sensitive option" happens to be selected in the standard CTRL <F> Excel function, it appears to effect the search feature of the worksheet.

I cannot duplicate the error on my laptop.

Anyone have any ideas or away to disable the "Case Sensitive" option from the searchstring code that has been modified for use in this workbook?

 

[HalfAce]

At the top of your code module you can try adding the line:
Option Compare Text