Delete Empty Rows

  • Thread starter Thread starter christian
  • Start date Start date
C

christian

Thanks for the assistance. Tried several different options but have
question on the amount of data it can process. When I run it against
100 row sheet the code works fine. When I try and run it against th
entire sheet (2628 rows) it just hangs. I've tried to let it run fo
30min (just in case) but no progress was shown.

Is there a limit on what excel can handle?

Thinking my only option is to break the sheet up into apx 500 rows pe
sheet and then running and cut and paste them back in.

Any ideas
 
I don't know what this looks like in the Excel forum, but in the newsgroup
where most of the answers are coming from, this stands by itself at the top
of a thread; so I doubt anyone knows what you are talking about. (in
otherwords, no one can see what you are referring to).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy rows with values in sheet 1 to next empty row in sheet2 2
What is going on here? (macro mystery) 3
Autohide rows based on formula in another sheet 0
VBA comparing sheets and cells 1
Excel Cannot delete empty cells/rows 4
Cut and Paste 4
Cut bottom 300 rows to next sheet & repeat 8
this code is VERY slow, is it the code or perhaps a worksheet issue 32

Back
Top