Results 1 to 21 of 21

Match function is malfunctining if variable is used as arg1

Threaded View

  1. #11
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague, Czech rep.
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    138

    Re: Match function is malfunctining if variable is used as arg1

    yap there are no data cause they get deleted on the menu initialization but that must be so every time its used there is a fresh set of variables. other data (that were used under the header) are of a personal character which is not to be shared....all the important data for this task are there trust me...;-)....if you click through as i explained above it will create few new entries on "krit" sheet and there raises the issue

    also the columns("B:B") refers to the range where only strings are - tried out with typename function set on the variable and on the cell itself always returns string

    btw. also tried to put "" to the match function (""" & choice(y) & """ ... ) didnt work either

    regarding no data thats what i explain in the edit2....i thought of that problem so i skipped first set of variables to get to the point where there are data but still flawed results

    Hope i´ve explained all thus far....;-)...now im off to try out the last thing you´ve proposed to declare MatB as variant which i didnt have (had it as long since the output should be numeric) but I´ll give it a shot lets see what´s the outcome....brb

    EDIT: so I´ve tried to declare MatB as variant and the only result was that in debug print it gives nothing instead of 0 if i had no "set" before the actual code or
    object required
    error message with match. highlighted
    Last edited by SoulPrisoner; 09-03-2013 at 09:09 AM. Reason: providing test results

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] MATCH function with a variable as lookup_value?
    By mccalle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-23-2013, 07:37 AM
  2. Adding a variable to index & match function using VBA
    By prestopr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-07-2013, 05:48 PM
  3. Replies: 2
    Last Post: 11-05-2011, 03:26 PM
  4. Specifying Arguments in Run ([Macro], [arg1],[arg2]...)
    By Kaigi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2010, 06:35 PM
  5. Using Match function output as a variable
    By iii in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-28-2009, 06:01 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