+ Reply to Thread
Results 1 to 3 of 3

mismatch error

  1. #1
    Registered User
    Join Date
    10-23-2015
    Location
    venezuela
    MS-Off Ver
    2010
    Posts
    1

    mismatch error

    hi i´m working in a code that gives you a value in a combobox depending on another combobox, but when i run it it gaves me a mismatech type of error, what do i need to change in my code ? or i can´t do what i want?

    Do While N°3.Value <> " "

    dcp = N°3.Value
    rownumber = WorksheetFunction.Match(dcp, npp, 0)
    Set Rangeppp = Sheets("BD").Range("D:D")
    pp1 = WorksheetFunction.Match(dcp, Rangeppp, 0)
    cinema = Sheets("BD").Range("F" & pp1).Value
    colum = WorksheetFunction.Match(cinema, "J" & "rownumber:rownumber" & "O", 0)
    DESTINO.Clear
    refref = Sheets("Lista").Range(rownumber, colum).Select
    ActiveCell.Offset(0, 1).Select
    Do While Not IsEmpty(ActiveCell)
    DESTINO.AddItem ActiveCell.Value
    ActiveCell.Offset(1, 0).Select
    Loop
    Loop

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: mismatch error

    1. colum = WorksheetFunction.Match(cinema, Range("J" & rownumber & "O:" & rownumber), 0)

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
    Ben Van Johnson

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: mismatch error

    Please Login or Register  to view this content.

+ 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. Run-time error 13: Type Mismatch error
    By mxlew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2015, 10:06 AM
  2. [SOLVED] run-time error '13' Type Mismatch error
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2014, 03:05 PM
  3. Type mismatch error- What is the reason behind the error message?
    By Endre111 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2014, 02:03 PM
  4. Complile Error: Type Mismatch ??? After adding error trap
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2012, 03:50 PM
  5. Conditional Formatting - Run Time Error '13' Type Mismatch Error
    By ksp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2011, 07:37 PM
  6. VB error, runtime error 13 (type mismatch)
    By hindlehey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2005, 08:37 PM
  7. Type Mismatch error & subscript out of range error
    By Jeff Wright in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2005, 03:06 PM

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