Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. zaka2003

    problem with worksheet search function in visual basic

    Skip, Now you're talking! Many thanks for your help! It's that "On Error Resume Next" that does it. And thanks to Cheerio for the generalisation of the method by creating user functions. Cheers Cherif
  2. zaka2003

    problem with worksheet search function in visual basic

    Skip, the issue remains unresolved! As I said, declaring dim n (or adding a format to n) makes no difference. Did you try it with a substring that's not in the search string? For example: N = Application.WorksheetFunction.Search("R", "SAMPLE"). rgds Cherif
  3. zaka2003

    problem with worksheet search function in visual basic

    thanks Geoff! that function solves the problem but there must be some way to resolve the SEARCH function issue. Rgds Cherif
  4. zaka2003

    problem with worksheet search function in visual basic

    Thanks for that but the declaration is already there as dim n integer. Using N = Application.WorksheetFunction.Search("S", "SAMPLE") works because "S" exists within "SAMPLE". If you try "R" for example, then N = Application.WorksheetFunction.Search("R", "SAMPLE") still gives an error!
  5. zaka2003

    problem with worksheet search function in visual basic

    Within an Excel spreadsheet I have a form whose code uses the worksheet SEARCH function. If the search string does not exist I get an error message. For example: N = Application.WorksheetFunction.Search("R", "SAMPLE") This gives an error "Unable to get the serach property of the worksheet...

Part and Inventory Search

Back
Top