+ Reply to Thread
Results 1 to 4 of 4

Thread: error 13 type mismatch - any idea ??

  1. 01-01-2012, 01:31 PM #1
    Blue_kul
    Blue_kul is offline
    Registered User
    Join Date
    12-29-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    15

    error 13 type mismatch - any idea ??

    I am getting this error, in attached worksheet, i tried to format all the cells accordingly but still getting same error.Test File.xlsm
    Last edited by Blue_kul; 01-04-2012 at 09:31 PM.
    Reply With Quote Reply With Quote
  2. 01-01-2012, 01:41 PM #2
    Blue_kul
    Blue_kul is offline
    Registered User
    Join Date
    12-29-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: error 13 type mismatch - any idea ??

    ok got it .. one of the cell was having space i guess i filtered all empty cells and deleted data if any and it worked... btw any idea if we can achieve it using any excel function ?
    Reply With Quote Reply With Quote
  3. 01-01-2012, 01:43 PM #3
    JieJenn
    JieJenn is offline
    Valued Forum Contributor
    Join Date
    12-14-2009
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    986

    Re: error 13 type mismatch - any idea ??

    For line Total2 = Cells(A + 1, 6).Value + Cells(A + 1, 7).Value, Excel does not recognize empty cell as 0. (5 + blank = error)
    To thank someone who has helped you, click on the star icon below their name.

    I hate reading

    Portfolio

    I need a job.
    I am young and incompetent
    Reply With Quote Reply With Quote
  4. 01-04-2012, 09:30 PM #4
    Blue_kul
    Blue_kul is offline
    Registered User
    Join Date
    12-29-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: error 13 type mismatch - any idea ?? 

        ActiveWorkbook.ActiveSheet.Range("G" & x).Select
    Selection.ClearContents
    .....has done job for me ... thanks !!!
    Reply With Quote Reply With Quote
+ 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)

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.2.0