Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Holly Fox   on Dec 18 In MS Office Category.

  
Question Answered By: Nixie Schmidt   on Dec 18

Try this:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim myRange As Range
Set myRange = ActiveSheet.Range("A10:A30")
If Target.Count = 1 Then
If Not (Intersect(Target, myRange)) And Target.Value = "" Then
Target.EntireRow.Delete Shift:=xlUp
End If
End If
End Sub

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Macro to delete entire row Or get search suggestion and latest updates.


Tagged: