+ Reply to Thread
Results 1 to 6 of 6

Run Time Error 13 Type Mismatch

  1. #1
    Registered User
    Join Date
    03-23-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    24

    Run Time Error 13 Type Mismatch

    Hi All,
    Need your help to sort out Why I am getting Run "Time Error 13 Type Mismatch" on the below line of code in Module...FYI I am calling this module in WorksheetChange event.

    Line of Error: For x = 1 To Cells(i, "u").Value



    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Run Time Error 13 Type Mismatch

    Is the value in Cells(i, "u") perhaps text, or an error?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    03-23-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Run Time Error 13 Type Mismatch

    Hi Norie,
    thanks for quick response...
    dropdown is there in cell Cells(i, "u"), that contains number from 1 to 10...and cell format is general

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Run Time Error 13 Type Mismatch

    The code should work then.

    Can you attach a sample workbook?

  5. #5
    Registered User
    Join Date
    03-23-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Run Time Error 13 Type Mismatch

    One more clue....
    code is throwing error on line no. 10...and this line contains column header...so I want to restrict this code to execute only from row 13 to last row...then I think code will execute properly...

    sample workbook creation is more complex task...because it contains so many event coding...

  6. #6
    Registered User
    Join Date
    03-23-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Run Time Error 13 Type Mismatch

    Hey all...
    Its solved now...I did the change as below
    Thanks for Your response Norie...

    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)

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