Results 1 to 7 of 7

Thread: Concatenating two ranges in MATCH function

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Jan 2019
    Posts
    3
    Location

    Concatenating two ranges in MATCH function

    Greetings to all! This is my first post!

    I've been trying to handle MATCH function, concatenating two ranges for multiple columns search and it keeps telling me Error "13".

    Here is the code line where it stops:

    UserForm1.TextBox2.Text = Application.Index(Sheets("Plan1").Range("A1:E73"), Application.Match(UserForm1.ComboBox1.Text & Month(Date), Sheets("Plan1").Range("A:A") & Sheets("Plan1").Range("B:B")), 4)
    Note that this comand works as a cell formula in the "Match Example" workbook when i use ctrl+shift+enter, but VBA is unable to handle that using the same structure.

    Can someone help?
    Attached Files Attached Files

Posting Permissions

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