RE: Using New VBA code

You have some extra spaces before the command 'entire row.delete'. Should be:

Selection.EntireRow.SpecialCells(xlBlanks).EntireRow.Delete

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kris" wrote:

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?

.

Relevant Pages

  • Re: Using New VBA code
    ... Microsoft MVP Excel ... "Kris" wrote in message ... some of the cells WITHIN THE SELECTION contain no data. ... The columns have pick lists build in some, but if I leave the pick list ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Using New VBA code
    ... Luke M ... some of the cells WITHIN THE SELECTION contain no data. ... 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. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: multiple pick from drop-down list
    ... Each sheet will have anywhere from a couple pay items up to ... selection model is the accidental over-writing of existing data. ... We have setup drop-down lists through data ...
    (microsoft.public.excel)
  • Re: Asp.net Dropdownlist selected index in changed
    ... back it will lose selection from fifth to first item in the list. ... The selected index of first two lists remain same but only thirds are ... private void BindSectionDropDownlist() ... Code for Searching according to the selection of third dropdown ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: multiple pick from drop-down list
    ... Let all your friends at NJDOT know that you are still working ... selection model is the accidental over-writing of existing data. ... We have setup drop-down lists through ...
    (microsoft.public.excel)
Loading