Deleting empty cells

**alexwick** · 12-01-2006, 01:30 PM

Hello,
i am trying to delet empty cells between rows. And of course i don't want it do manual since we are talking about 4000-5000 cells. Maybe with a function or so !?!

Like:

A

B

C

D

should be to:

A
B
C
D

I hope you understand what i mean....
PLEASE i need help...

thank you
Alex

**VBA Noob** · 12-01-2006, 01:33 PM

Hi,

Select Column then Data > Filter > Autofilter and then select non blanks and delete rows

VBA Noob

**alexwick** · 12-01-2006, 01:37 PM

thank you...
i messed up the format here and posted again....
i will answer there ..

Alex

**alexwick** · 12-01-2006, 01:47 PM

that is wiered that second post is gone....!

oh well...

i tried and it doesn't do the job i want.
you can filter the empty rows, but it also effekts the other data on the sheet..
it is hard to explain...i attache a small excel data as an sample what i mean...

I hope somebody can help !!
thank you

Alex