Remove blank cells from the list

Hi all,

I have a list of names that feeds a listbox (forms). With the following code I want to remove names from the list one by one. The code works, but there is a part of it still missing. The code moves value from the list but leaves a gap there (blank cell), therefore listbox also reflects it and it doesn't look professional. Any idea?

By the way, 'sort' is not an option. The code should just to remove blank cell.

Please Login or Register  to view this content.

Hi, mate. Sorry, I was in a meeting, so couldn't pick it up. Yes, your code works. I'm just not sure if it will not upset formulas as deleting cell and shifting cells up is not very friendly to formating and formulae. What do you think? I am not able to test your code on the original workbook yet.

Yes, as I predicted, it messed up all it could. Is there an alternative code to this?