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-09T17:06:40+00:00

    Hi

    Please add to the code

    Dim MyRng, rng As Range

    Set MyRng=ActiveSheet.Selection

    For Each rng in MyRng

    The rest of your code...

    Do let me know if you need more help 

    Regards 

    Jeovany

    Was this answer helpful?

    0 comments