prevent run macro based on merged cells and pops up message

[Hasson]

hi experts

I search for addion some lines before macro . so if there is any merged cells in sheet1 , then should pops up message " you can't complete this procedure ,please get rid of merged cells"

and should not run the macro ,otherwise should run the macro .

thanks

 

[FormR]

Hi, you could try something along the lines of:

With Sheets("Sheet1").UsedRange
    If IsNull(.MergeCells) Or .MergeCells = True Then
        MsgBox "Get rid of those pesky merged cells!!", vbExclamation
        Exit Sub
    End If
End With
'The rest of your code..

 

[Hasson]

Awsome !!
many thanks