match function vba

  1. T

    Variable as lookup value in Match Function in macro

    I new to programing in vba but have other programing experience. The one thing that keeps getting me is the formatting that vba uses. Is there a way to use a variable as the lookup value within the match function in a macro? I have tracked my problem down to the match function not being able...
  2. nardagus

    match and index macro question

    Hello guys and girls, I'd like to ask you a question about macro I made. I'm totally newbie in writing macros so forgive me taking your time with such a simple thing. :) Sorry for not using HTMLMaker but I get an error about "type mismatch" in excel version section (I'm using E2010). Any way...
  3. A

    converting excel function to VBA

    anyone have an idea how to convert a match statement to vba with multiple conditions? I have situations from where it has to match two criteria, to matching six criteria. Any thoughts on how to do this? =IF(AND(ISNUMBER(MATCH(1,($K$2:$K$393=Y2)*($O$2:$O$393=$D$1),0))...
  4. W

    Unable to get the Match Property of the WorksheetFunction class error

    I'm getting the error: "Unable to get the Match Property of the WorksheetFunction class" and I'm not sure why. I've seen several other posts with this issue, however have not been able to find a solution. I attempted to use an IsError Function to see if the Match function just wasn't finding the...
  5. T

    UserForm ComboBox Exclude Blanks

    All, I have a dynamic range serving as a RowSource for a list that populates a ComboBox in a userform. I only want the user to see the non-blank items in that range. I am also using the selection to run a application.match off of so I need to retain it to pre-populate some textboxes. How can...
  6. P

    match formula in vb

    <TABLE style="WIDTH: 213pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=284 border=0 x:str><COLGROUP><COL style="WIDTH: 112pt; mso-width-source: userset; mso-width-alt: 5449" width=149><COL style="WIDTH: 101pt; mso-width-source: userset; mso-width-alt: 4937" width=135><TBODY><TR...
  7. S

    IsNA and Match Function Error in VBA

    I am trying to test a list to verify that a string (Name) exists before I move on in the program. I was trying to use an IsNa function combined with a Match function to generate a True or False answer. The code works if the code generates a variable that is False and fails if the value is...

Some videos you may like

This Week's Hot Topics