Jul 03 2019 04:59 AM
Hello everyone. I'm looking for a macro that could help me deleting different rows in different sheets. For example rows 5 to 50 in worksheet A, rows number 7 to 40 in worksheet B and the rows number 10 to 60 in worksheet C. I was wondering if someone could help me with it. Thanks.
Jul 03 2019 07:03 AM - edited Jul 03 2019 07:04 AM
SolutionHello @Edrisbas,
Try this Sub in VBA:
Sub Delete_Rows()
' Delete_RowsA Macro
Sheets("A").Select
Rows("5:50").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
' Delete_RowsB Macro
Sheets("B").Select
Rows("7:40").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
' Delete_RowsC Macro
Sheets("C").Select
Rows("10:60").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
End Sub
Hope this helps!
PReagan
Jul 03 2019 11:14 PM
Hi@PReagan
It's exactly what I was looking for. Thank you very much.
Jul 03 2019 07:03 AM - edited Jul 03 2019 07:04 AM
SolutionHello @Edrisbas,
Try this Sub in VBA:
Sub Delete_Rows()
' Delete_RowsA Macro
Sheets("A").Select
Rows("5:50").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
' Delete_RowsB Macro
Sheets("B").Select
Rows("7:40").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
' Delete_RowsC Macro
Sheets("C").Select
Rows("10:60").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
End Sub
Hope this helps!
PReagan