Delete empty lines in cell range

**abjac** · 08-26-2020, 08:07 AM

Hi I have below code which original was delivered from Jindon. Its an excellent code. And it was made to delete empty lines in a textbox original.
I forgot ask how to use in in a cell range and do the same.
I made below code which good but only in one cell.- I have tried much to change it so it works in cell range, but always some error.
The code now do the job in cell B16. But i would like it to be changed so it works in range example X7:X16.
It seems like excel forum have issues. But i hope i manage to get it posted correct.
Please have a look at the code.
Sincerely
Abjac

Please Login or Register  to view this content.

**jindon** · 08-26-2020, 08:29 AM

This should work on both Cell/TextBox

Please Login or Register  to view this content.

Edit:
missed

would like it to be changed so it works in range example X7:X16.

**abjac** · 08-26-2020, 09:14 AM

HI Jindon and thanks alot for look at it. Little correction. It works perfect. I just added so it goes to sheet 2. Thats why it did not work first time. But its just
perfect. Not sure i can give you reputation again so short time after. But i would like to say all the years i have been a member of this board. You with your
fantastic skills have helped me and many others, who like these macros but dont have your sklls. So i can only say thanks alot sure many others will say the same.
Have a nice day.
Sincerely
Abjac

**jindon** · 08-26-2020, 09:21 AM

You are welcome and thanks for the kind word.

Delete empty lines in cell range

LinkBack

Thread Tools

Rate This Thread

Display

Delete empty lines in cell range

Re: Delete empty lines in cell range

Re: Delete empty lines in cell range

Re: Delete empty lines in cell range

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Delete empty lines in textbox but keep existing lines.

[SOLVED] Find last empty cell from range, then delete rows?

[SOLVED] Delete cell contents if the corresponding range is empty

How to delete entire row if first cell of it is empty for specific range and worksheets

[SOLVED] Macro to delete entire row (within a specified range) if cell in column A is empty

Print range without empty lines

find <> empty cell in range, delete entire row

Bookmarks

Bookmarks

Posting Permissions