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
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?
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
VBA Code:
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?