Re: Using New VBA code
- From: "Don Guillett" <dguillett1@xxxxxxxxxxxxx>
- Date: Wed, 10 Dec 2008 13:49:42 -0600
Why are you RE-posting the same question?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Kris" <Kris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1021FC7E-0AED-4662-9BEA-6E7A0BBB493A@xxxxxxxxxxxxxxxx
I am trying to set up a macro to delete rows if some of the columns in the
row do not contain data.
here is the code that I am using:
Sub DeleteBlankRows2()
'Deletes the entire row within the selection if _
some of the cells WITHIN THE SELECTION contain no data.
On Error Resume Next
Selection.EntireRow.SpecialCells(xlBlanks) . EntireRow.Delete
On Error GoTo 0
End Sub
The columns have pick lists build in some, but if I leave the pick list
blank I want it to delete the entire row. When I run the macro I get a
Syntax Error that says something is not set up right.
Can anyone help me?
.
- References:
- Using New VBA code
- From: Kris
- Using New VBA code
- Prev by Date: Textbox added to Form at runtime too small, can't control size and change event won't trigger
- Next by Date: Random Whole Number Functions
- Previous by thread: Re: Using New VBA code
- Next by thread: mutliple criteria vlookups
- Index(es):
Relevant Pages
|
Loading
