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:38:12+00:00

    30 lines to be removed so sorry in new table 144 lines.

    1. Highlight duplicate rows
    2. Don't merge
    3. Where Income paid and Grand total = 0 for both columns (E,F) remove lines
    4. Copy and paste with no formulas in new table

    Your support is very much appreciated...your a pro

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-02-13T10:30:08+00:00

    OK..working

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-02-13T10:22:02+00:00

    Sorry new table should read 144 lines

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-02-13T10:16:02+00:00

    Was this answer helpful?

    0 comments