+ Reply to Thread
Results 1 to 5 of 5

How to add parameters to the find function vba

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    68

    How to add parameters to the find function vba

    hi everyone, does anyone know how to add parameters to the find function in excel vba? i have never really use parameters i don't think and i'm so confused about how to code it!, HELP!

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: How to add parameters to the find function vba

    What parameters...? All the available ones will be listed in IntelliSense as you type - you do have Intellisense turned on, don't you?

    Failing that, the Help file will give you all the information you need.
    Last edited by cytop; 01-07-2014 at 08:00 AM. Reason: typo

  3. #3
    Registered User
    Join Date
    02-12-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: How to add parameters to the find function vba

    What i need parameters is for is to find a exact number in a worksheet because when i search for 1 it searches and finds 10 because its got a 1 in it

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: How to add parameters to the find function vba

    Please Login or Register  to view this content.
    If you're looking for values, you really should pass a value. Finding a partial match for 1 seems to indicate you're looking for a string.
    Last edited by cytop; 01-07-2014 at 08:57 AM.

  5. #5
    Registered User
    Join Date
    02-12-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: How to add parameters to the find function vba

    how do you set your code to a particular range?

+ 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] Find a cell based on parameters
    By MikeMar! in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2013, 05:39 PM
  2. Find out the parameters from data table
    By alee001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-05-2012, 04:27 AM
  3. Find and Extract URLs with certain parameters
    By superblogger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2011, 06:06 PM
  4. Multiple parameters in function
    By Ranjani in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-10-2009, 07:58 PM
  5. Find the 4 parameters in order to design one line
    By skimer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2006, 06:10 AM

Tags for this Thread

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