simple help needed please

  • Thread starter Thread starter ian123
  • Start date Start date
I

ian123

i often get data with lots of blank rows between the data at random
intervals which i'd like to eliminate.

Does anyone know a good macro for deleting rows that can handle
"overlapping selections"- ie where the are groups of rows of data, then
rows of empty cells, then data rows, then empty for etc etc etc!

Thanks very much for any help
 
ian

Select a column and Edit>Go To>Special>Blanks>OK

With blank rows selected Edit>Delete>Entire Row.

Turn on the Macro Recorder while you're doing this.

Gord Dibben Excel MVP
 
You could just sort the data then the empty rows will be at the bottom!
 
Wouldn't the easiest would be sort by blanks and just delete all blanks.
Or use a specialcells(xlblanks) macro to delte
 
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

easiest way to find next non blank row 5
Please help 10
Dynamic Chart ranges 6
Code to delete rows with varying amounts of data 2
Check row above for information if it has contents copypaste empty 1
Search for empty cells and move cells next to 10
VBA comparing sheets and cells 1
Searching question 3

Back
Top