Hello!
I have a sheet with many different data blocks of different sizes. These blocks have a random number of empty rows between them. I want to have only a single empty row between them. How can I deleted the other empty rows?
Hello!
I have a sheet with many different data blocks of different sizes. These blocks have a random number of empty rows between them. I want to have only a single empty row between them. How can I deleted the other empty rows?
Perhaps this code of JasonB75
![]()
Please Login or Register to view this content.
Edited: To speed up code
Last edited by Sintek; 04-21-2017 at 05:46 AM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
This works very well, thank you very much! It takes some processing time, is there a way to speed it up?
Excellent, thank you so much!
pleasure, thanksfor rep points...Please mark thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks