Please can someone assist me in trying to delete two rows in between a named range (not including the named ranges)? I currently have:
Sub ClearDMM()
Rows(Range("DMMCI").Row + 1 & ":" & (Range("DMMCI2").Row - 1)).Delete
End Sub
The problem is if the macro / button is run twice then as you'll see above ("DMMCI2").Row + 1 is the row above ("DMMCI").Row - 1 and therefore gets deleted.
Is there a better way to only delete rows in between a named range if the upper and lower row are not next to eachother? Or a totally different way?
Many thanks for your help,
Shane
Bookmarks