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-12T13:07:42+00:00

    You Are right I have started an excel sheet and has been posted in one drive

    https://onedrive.live.com/?id=5B91884861232582%21718&cid=5B91884861232582

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-02-12T13:30:54+00:00

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-02-12T13:33:40+00:00

    I have a doubt, you have highlighted many cells in pink even though description is not Closing Balance.

    Do I need to ignore Closing Balance logic?

    Also see row numbers 17 and 18 where dates are same but descriptions are different.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-02-12T13:50:11+00:00

    Closing Balance have to be included for row 119 only

    Rows 17 and 18 remains as is

    Income Paid 0.0 for both and Grand Total row 17 $137,495.00

                                                   Grand Total row 18 $ 244,338.65

    Was this answer helpful?

    0 comments