Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm new to VBA and trying to learn how to write code. My objective is
to automatically delete entire rows between row 19 and row 28 when the value in column 11 in any of these rows is empty (null). Following is the code I've written which, of course, does not work. Public Sub Delete_Rows() Dim GlobalRange As Range Dim Range As Range Set GlobalRange = Application.ActiveSheet.Range("N19:N28") For Each Range In GlobalRange If Range.Cells = "null" Then EntireRow.Delete Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get old rows to auto delete when new are added? | Excel Discussion (Misc queries) | |||
If formula result is false, how do I auto-delete that rows? | Excel Worksheet Functions | |||
Auto Filter Delete Rows by Criteria Doesn't Work Range To Complicated | Excel Programming | |||
Need help to auto delete 4 of every 5 rows | Excel Programming | |||
Auto Delete rows | Excel Programming |