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-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
  2. 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
  3. 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
  4. Anonymous
    2020-02-12T15:23:24+00:00

    I didn't code the transfer. What I want you to populate New Table from your first table. So that I understand what is output needed. Then I can code appropriately.

    Was this answer helpful?

    0 comments