simple help needed please
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 --- Message posted from http://www.ExcelForum.com/ |
simple help needed please
ian
Select a column and EditGo ToSpecialBlanksOK With blank rows selected EditDeleteEntire Row. Turn on the Macro Recorder while you're doing this. Gord Dibben Excel MVP On Wed, 17 Dec 2003 15:11:35 -0600, ian123 wrote: 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 --- Message posted from http://www.ExcelForum.com/ |
simple help needed please
You could just sort the data then the empty rows will be at the bottom!
-- Regards, Rocky McKinley "ian123" wrote in message ... 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 --- Message posted from http://www.ExcelForum.com/ |
simple help needed please
Wouldn't the easiest would be sort by blanks and just delete all blanks.
Or use a specialcells(xlblanks) macro to delte -- Don Guillett SalesAid Software "ian123" wrote in message ... 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 --- Message posted from http://www.ExcelForum.com/ |
simple help needed please
columns(1).SpecialCells(xlBlanks).entireRow.Delete
-- Regards, Tom Ogilvy ian123 wrote in message ... 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 --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 12:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com