VBA to delete row which has a merged cell

[GlennL]

Hellom

I have a cell which is merged from from C10 to H20.

I can select row 12, right button and delete the entire row and the entire row is deleted.

If I record the process, I get

Sub Macro3()
'
' Macro3 Macro
'

'
    Rows("12:12").Select
    Selection.Delete Shift:=xlUp
End Sub

When I run the code above rows 10 to 20 are selected and deleted.

How can I get the one row to be deleted using VBA?

 

[Peter_SSs]

Try

Rows(12).Delete

 

[Skyybot]

This may work too.

Sub deleteRow()

ActiveSheet.Rows(Selection.Row).Delete

End Sub