Delete empty cells and shift remaining left

**kiboodez** · 10-07-2008, 07:14 AM

Hi there,

I am looking for a method which would delete empty cells in a row, and then shift the remaining data to the left (filling the cells with data). I know that this could be done manually, but I need it completed for 3000 rows! I have attached a simple sheet to show what I'm Looking for.

Hope someone can help.

**StephenR** · 10-07-2008, 07:23 AM

Try this:

Please Login or Register  to view this content.

**kiboodez** · 10-07-2008, 07:41 AM

I have pasted the code in, but how do I activate it?

**jburbea** · 06-25-2010, 02:17 PM

insert that line between the following lines:
sub RemoveBlank()
end sub

Delete empty cells and shift remaining left

LinkBack

Thread Tools

Rate This Thread

Display

Delete empty cells and shift remaining left

Thanks...

Re: Delete empty cells and shift remaining left

Thread Information

Users Browsing this Thread

Similar Threads

Move between Input Cells Only by Tab, Enter, and Arrows

Delete with shift causes cells loose fill & border around

Insert, shift cells down and populate

SHIFT + ENTER not working on some cells Excel 2003

Delete cell and shift cell up

Bookmarks

Bookmarks

Posting Permissions