If Statement in vba to Delete a Line

		Microsoft Office Forums > Microsoft Excel > Excel Programming
If Statement in vba to Delete a Line

FAQ

Thread Tools

Display Modes

04-02-2014, 03:11 PM

macropod

Windows 7 32bit If Statement in vba to Delete a Line

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

OK, try:

Code:

Sub Demo()
Dim iRow As Long
With ActiveSheet.UsedRange
  For iRow = .Cells.SpecialCells(xlCellTypeLastCell).Row To 1 Step -1
    If .Range("A" & iRow).Value = "(blank)" Then
      .Rows(iRow).EntireRow.Delete
    End If
  Next iRow
End With
End Sub

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why cant I delete the black line at the side of my orginisational chart?	Gabby1991	Drawing and Graphics	1	01-07-2014 09:14 PM
unable to delete a horizontal line	jerryny	Word	2	03-31-2013 05:59 PM
Search for text then delete line	konopca	Word VBA	2	06-07-2012 02:44 AM
Very Urgent - Not able to delete Line	krishnaoptif	Drawing and Graphics	11	05-29-2012 11:25 AM
Cannot delete line	adkr	Office	1	04-07-2010 09:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:24 AM.