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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2020-02-09T18:35:28+00:00

    Hello V find the output result

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-02-09T18:40:29+00:00

    Hi LZ this table doesn't come from access but create from Excel (Tab name is access). I put the following code provided by

    Jeovany and when I try to execute I have the following error

    Was this answer helpful?

    0 comments
  3. Lz365 38,201 Reputation points Volunteer Moderator
    2020-02-09T18:50:06+00:00

    OK JF_2010,

    data don't come from Access, my question remains though: is A1:H172 formatted as a Table or not?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-02-09T19:11:13+00:00

    Table AccessDownload (A1:H172)  Merge cells where dates are the same and if description is closing Balance. This is not a table created from access. But I use sometimes this table to upload the data in Access. 

    I want to merge Column A where dates are duplicate and want to Sum the Value of (column E) and the Total Value of (column H) only if Description (Column B) = Income Paid

    Example Year 2013 =SUMIF($B$33:$B$55,"Income Paid",$E$33:$E$55). I inserted the code provided by Jeovany and it provides run Time error 438

    Was this answer helpful?

    0 comments