+ Reply to Thread
Results 1 to 6 of 6

Search value in multiple worksheets

  1. #1
    Registered User
    Join Date
    07-20-2018
    Location
    Hong Kong
    MS-Off Ver
    2007
    Posts
    60

    Search value in multiple worksheets

    Dears,

    I am writing a Search function in my VBA.

    The workbook has multiple worksheets. The worksheets are namely by sheet code (Sheet1 to Sheet4).

    Can anyone help rewrite the following code and then I can use NewArrive, TakeOut, SendBack and ShipOut as the worksheet name instead of Sheet1 .... Sheet4?

    Kind Regards,
    Oliver


    Please Login or Register  to view this content.
    Last edited by oliverliu2; 08-18-2019 at 11:19 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Search value in multiple worksheets

    try

    Please Login or Register  to view this content.
    Last edited by k1dr0ck; 08-17-2019 at 09:02 PM.

  3. #3
    Registered User
    Join Date
    07-20-2018
    Location
    Hong Kong
    MS-Off Ver
    2007
    Posts
    60

    Re: Search value in multiple worksheets

    Dear k1dr0ck,

    It works fine. What if I need to find the search in all the worksheets?

    Regards,
    Oliver

  4. #4
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Search value in multiple worksheets

    try

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-20-2018
    Location
    Hong Kong
    MS-Off Ver
    2007
    Posts
    60

    Re: Search value in multiple worksheets

    Dear k1dr0ck,

    The problem is solved.
    Have a nice day.

    Regards,
    Oliver

  6. #6
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Search value in multiple worksheets

    good to know, you can now mark this thread as solved using the thread tools above your very first post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Search multiple columns from Multiple Worksheets and copy rows into a Summary Worksheet
    By kljohn01 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-07-2017, 03:46 PM
  2. [SOLVED] Search for multiple cell contents in multiple text strings on two different worksheets
    By Sinistra in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-07-2017, 07:29 AM
  3. [SOLVED] Search multiple worksheets for search term and paste results in a summary sheet
    By Andy15 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 04-03-2017, 01:49 PM
  4. [SOLVED] Search box in Excel to search key words in sentences in multiple worksheets
    By fernandoii676 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-05-2012, 01:42 PM
  5. Replies: 2
    Last Post: 10-19-2012, 11:11 AM
  6. Search Multiple Worksheets Against List of Non-Exact Search Criteria?
    By thump4r in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2010, 03:46 PM
  7. Search in Multiple Worksheets
    By Lizz45ie in forum Excel General
    Replies: 0
    Last Post: 10-19-2005, 12:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1