+ Reply to Thread
Results 1 to 9 of 9

run-time error '13' type mismatch

  1. 09-10-2014, 03:32 AM #1
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    run-time error '13' type mismatch

    please help me why showing like this

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 09-10-2014, 03:45 AM #2
    nathansav
    nathansav is offline
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: run-time error '13' type mismatch

    Wheres the error? You need to put as much info as possible, we cant see your computer or data or the error.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me
    Reply With QuoteRegister To Reply
  3. 09-10-2014, 04:02 AM #3
    Bob Phillips
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: run-time error '13' type mismatch 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 09-10-2014, 04:40 AM #4
    millz
    millz is offline
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: run-time error '13' type mismatch

    Error here:
    Please Login or Register  to view this content.
    change to:
    Please Login or Register  to view this content.
    Unless if Sheet1 is a global variable that I cannot see.
    多么想要告诉你 我好喜欢你
    Reply With QuoteRegister To Reply
  5. 09-10-2014, 04:54 AM #5
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: run-time error '13' type mismatch

    thanks

    but now i am getting same error in this line

    Please Login or Register  to view this content.
    Last edited by baig123; 09-10-2014 at 04:57 AM. Reason: paragraph
    Reply With QuoteRegister To Reply
  6. 09-10-2014, 05:04 AM #6
    Hawkeye16
    Hawkeye16 is offline
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: run-time error '13' type mismatch

    try cell.value so you can get the value of the cell.
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
    Reply With QuoteRegister To Reply
  7. 09-10-2014, 05:28 AM #7
    nathansav
    nathansav is offline
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: run-time error '13' type mismatch

    I'd have a look at some VBA articles Baig, what you are posting is what you can sort by reading the correct syntax for things.
    Reply With QuoteRegister To Reply
  8. 09-10-2014, 06:18 AM #8
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: run-time error '13' type mismatch

    Quote Originally Posted by baig123 View Post
    thanks

    but now i am getting same error in this line

    Please Login or Register  to view this content.
    Maybe?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 09-10-2014, 06:25 AM #9
    baig123
    baig123 is offline
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: run-time error '13' type mismatch

    Thanks for sharing ur knowledge
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Run Time Error 13 . Type mismatch
    By TERRI LEE in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-09-2014, 03:24 PM
  2. [SOLVED] Run time error 13 - Type mismatch
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2013, 08:30 AM
  3. [SOLVED] Run-time error '13': Type mismatch
    By smonzon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2013, 12:42 AM
  4. Run Time Error 13 Type Mismatch
    By nahge123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-07-2012, 05:46 PM
  5. run-time error 13 type mismatch
    By godster84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2007, 11:29 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1