Delete Rows

[cmonthetic]

Hi,

The spreadsheet I am working with has a large number of empty rows.

As the sheet is sent to me and it is made up of several other imported spreadsheets so I never know how many blank rows I am going to have.

I know that the cells in column A only every contain a serial number and are blank otherwise.

Is there a quick way of selecting the blank cells from column A and then deleting all of the blank rows.

TIA

 

[SkipVought]

Hi,

Use the AutoFilter.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[cmonthetic]

Hi,

Thanks for the response SkipVought.

I really want to do this automatically by using a macro or something. Basically I just want to strip out all of the rows that do not contain any data.

Don't know if there is a way of doing this :|

 

[Johnny42]

http://www.cpearson.com/excel/deleting.htm

 

[TonyJollans]

Hi cmonthetic,

Select Column A
Edit > Goto > Special > Blanks
Press [blue]Ctrl -[/blue] (to delete) and choose Entire row

As this is the VBA forum, the code for that is:

[blue][tt] Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[SkipVought]

The Macro Recorder is an excellent tool.

Macro record turning on the auto filter, filtering and deleting.

Then all you have to do is clean up your code.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}