none
Excel Macro CellFormat Runtime Error RRS feed

  • Question

  • Hi, 

    I am trying to execute the code below, which is supposed to find all merged cells in a region, but I keep getting "Runtime error 424" Object required. I tracked the error to the first line of the If statement. I thought the CellFormat was an object, so not sure why I get that error on that line.

    Is there anyone who can give some guidance?

    Sub Merge()

    Range("A1").Select

    ActiveCell.CurrentRegion.Select

    If CellFormat.MergeCells = True Then
        Selection.EntireRow.Delete
    End If



    End Sub

    Friday, September 8, 2017 4:58 PM