Empty Rows

**vijay2482** · 03-09-2009, 04:28 AM

hi all,

how to move the empty rows to the last filled rows in excel using macros?

thanks in advance

**Shijesh Kumar** · 03-09-2009, 04:49 AM

what does moving the empty rows mean..
do you want to delete the empty row...

**vijay2482** · 03-09-2009, 05:51 AM

i dont want to delect.
just push the filled rows up and the empty rows after the last filled in row

**davegugg** · 03-09-2009, 04:35 PM

So you are saying you just want to delete all empty rows in your data, so there are no blank rows until after you last row of data. Is that right?

**vijay2482** · 03-10-2009, 08:59 AM

thanks for your replies

Re: Empty Rows