Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing rows that have a blank column B only
I would like to run a macro to do as follows.
on a day to day basis I'm given a spreadsheet. The headers/columns are all the same. I sort column 'B' which is the key information I need. Anything blank in column B is useless to me. So I highlight all the rows that have a blank column B and delete them. obviously with every spreadsheets sometimes there's only 2 rows to be deleted and sometimes there's 200. is there a way to write a macro that would do this automatically for me, instead of having to do this manual everyday. I tried using Selection.End(xlDown) but it takes me to the bottom of all the records. all of column A has a value, and sometimes column C has a value (if this helps). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing rows that have a blank column B only
Hi Savbci,
Try: Sub Tester() On Error Resume Next Columns("B:B").SpecialCells(xlBlanks).EntireRow.De lete On Error GoTo 0 End Sub --- Regards, Norman "savbci" wrote in message ... I would like to run a macro to do as follows. on a day to day basis I'm given a spreadsheet. The headers/columns are all the same. I sort column 'B' which is the key information I need. Anything blank in column B is useless to me. So I highlight all the rows that have a blank column B and delete them. obviously with every spreadsheets sometimes there's only 2 rows to be deleted and sometimes there's 200. is there a way to write a macro that would do this automatically for me, instead of having to do this manual everyday. I tried using Selection.End(xlDown) but it takes me to the bottom of all the records. all of column A has a value, and sometimes column C has a value (if this helps). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Blank Rows ? | New Users to Excel | |||
Removing blank rows | Excel Programming | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Copying and pasting a worksheet to a blank and removing blank rows | Excel Programming | |||
Removing Blank Rows? | Excel Programming |