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-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
  2. Anonymous
    2020-02-12T15:21:39+00:00

    V.

    I included the Original Table without the Module.

    Can you insert the module with your code, and see if the transfer is working

    Thank you

    https://onedrive.live.com/edit.aspx?cid=5b91884861232582&page=view&resid=5B91884861232582!977&parId=5B91884861232582!718&app=Excel

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-02-12T14:59:19+00:00

    I merged the cells in original table itself.

    Can you put the output in new table so that I can generate that output through VBA?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-02-12T14:49:11+00:00

    I inserted your macro in module 1 and I don't see the transfer in new table. The Final Copy Module 1- Copy.xlsm

    with the Module 1 is in one drive .

    https://onedrive.live.com/edit.aspx?cid=5b91884861232582&page=view&resid=5B91884861232582!975&parId=5B91884861232582!718&app=Excel

    Was this answer helpful?

    0 comments