+ Reply to Thread
Results 1 to 3 of 3

Find within specific sheet

  1. #1
    Registered User
    Join Date
    06-22-2018
    Location
    suisse
    MS-Off Ver
    office 2016
    Posts
    59

    Find within specific sheet

    Hello,
    I have this code but it search within all worksheets on the workbook, I want to be able to search just within a specific sheet and not the usedrange.
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Find within specific sheet

    How would you like to inform about the sheet name ??:
    Name mentioned in the macro
    Message box.
    If the "usedrange" is not used what else, do you want to reduce the range ???
    Please explain
    Last edited by PCI; 09-13-2018 at 10:51 AM. Reason: bow changed to box
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    06-22-2018
    Location
    suisse
    MS-Off Ver
    office 2016
    Posts
    59

    Re: Find within specific sheet

    Yes in a reducedrange, for example i just want to search for a value on the sheets ("suivi2") but don't know how to apply it to this code

    Please Login or Register  to view this content.
    Edit: I found a solution to my problem.
    I’m going to mark this thread as solved
    Last edited by dark_prince69; 09-11-2018 at 04:01 PM.

+ 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. find specific text and enter value un new sheet
    By Swapijs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-19-2017, 07:22 AM
  2. [SOLVED] Find a specific value in all sheets then activate that sheet before close
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2017, 04:19 AM
  3. Find specific word in Column A & copy that row & the next 30 rows to a new sheet
    By ludsonline in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2017, 08:04 AM
  4. Find sheet in different work and find specific value on that sheet
    By jimstrongy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2017, 09:36 AM
  5. [SOLVED] Find and copy specific data from one sheet to another
    By antexity in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-24-2013, 02:04 PM
  6. [SOLVED] Need help, macro to find all rows with specific value, cut and paste to a different sheet
    By dieseldogpi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2012, 02:47 PM
  7. Lookup/Find Sheet then give value of specific cell within sheet
    By DoriBeE in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2011, 08:42 AM

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