This deletes the cells in the range "B2:F2".
If the Shift argument is omitted then Excel will guess the best direction based on the shape of the range.
Even with displayalerts = false you will get the following prompt if the selection currently has a filter applied to it.
Delete entire row ?
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext