Excel VBA Merge Cells for a Table run time error"1004"

Anonymous
2020-02-09T15:51:00+00:00

Table AccessDownload (A1:H172)  Merge cells where dates are the same and if description is closing Balance

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

65 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-13T10:00:33+00:00

    https://onedrive.live.com/?id=5B91884861232582%21718&cid=5B91884861232582

    V this is not what I was expecting

    1. 13 rows should be merged and 13  lines should have been removed. total lines 172 minus 11 = remaining lines 161
    2. the macro should leave active sheet intact and the results should posted in new table (10 lines where description is Income Paid and 1 line with closing balance

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-02-13T06:18:08+00:00

    The macro merges two rows

    119 and 120

    149 and 150

    You will need to change the formula in master table. Put following formula in F119

    =IF(OR(A119=A120,A120=""),IF(B119="Closing Balance",C119+C120+D119+D120,D120))

    This will make sure that your formula is executed even if A120 is blank.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-02-12T19:14:19+00:00

    Hi V

     I ran your code and the only lines that were merged are line 119 and 120

    Instead of false the amount should be $217,924.83

    Is there something I'm doing wrong?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-02-12T17:24:40+00:00

    The excel file which you have posted already contains the code.

    You will need to download the workbook.

    You can copy the first table into second sheet.

    You can click anywhere in second sheet to make it active (The code runs on active sheet)

    And press ALT+F8 to display the macros.

    You can run MergeCells macro.

    Was this answer helpful?

    0 comments