Delete range only working once

Hai @Tammy1998
How to delete Last Row in excel with dynamic Range? Take this fr ur reference , this will help in somewhere of ur task