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: Newest
Most helpful Newest Oldest
  1. 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
  2. Anonymous
    2020-02-12T17:20:26+00:00

    Hi V

    Need same table (one existing on one drive) with your code inserted in a module which with your module be copied in the new table. That'll will allow you to test if your code is working.

    Thanks for your support

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-02-12T16:47:17+00:00

    Sorry, let me rephrase it.

    Do you need the same table copied in new sheet but merging done on the basis of criteria done by you?

    OR

    Only those rows which are merged should be transferred to new sheet?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-02-12T16:18:30+00:00

    V.

    What I sent you is the new table I can rename the name in one drive but this is the original. What else can I do?

    Was this answer helpful?

    0 comments