+ Reply to Thread
Results 1 to 3 of 3

Macro SUM 2 Colums & Delete Row, but Works in 1 worksheet but in other WSheet Doesn't Work

  1. #1
    Registered User
    Join Date
    06-06-2012
    Location
    Mexico
    MS-Off Ver
    Excel 2010
    Posts
    99

    Macro SUM 2 Colums & Delete Row, but Works in 1 worksheet but in other WSheet Doesn't Work

    Hi everyone!!

    Good afternoon!!

    I have this macro:

    Please Login or Register  to view this content.
    And Works, but the information is incorrect, maybe it's a problem in the order..
    The purpose of the macro is to detect if there are duplicates values in column "B" and sum in the column "H"
    .. attach the file!!

    Thanks again!
    Best Regards!!

    captura.jpg
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Macro SUM 2 Colums & Delete Row, but Works in 1 worksheet but in other WSheet Doesn't

    Quote Originally Posted by feroguz View Post
    And Works, but the information is incorrect, maybe it's a problem in the order..
    Can you explain this a bit please. I could get exact results in all the worksheets I run this code. Is it the worksheet in the same workbook or are you trying to run in other workbook?

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro SUM 2 Colums & Delete Row, but Works in 1 worksheet but in other WSheet Doesn't

    Hi feroguz,

    Here's another way:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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