Hi, If you see the file I have attached you will understand it better.
When I ran the code the data was deleted but the rows was not deleted.
In this file>Goto Metal sheet > and press Delete button.
You will understand the difference.
Thanks in advance.