Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The offset was moving to the next line before deleting.
Sub DeleteGrandTotalPlus() Dim oFound As Range Set oFound = Cells.Find("Grand Total") If Not oFound Is Nothing Then oFound.Resize(4, 1).EntireRow.Delete End If End Sub "Duncan J" wrote in message ... I'm trying to Delete the row "Grand total" and the 3 rows below it. I tried this but it's ot working. Dim oFound As Range Set oFound = Cells.Find("Grand Total") If Not oFound Is Nothing Then oFound.Offset(1, 0).Resize(3, 1).EntireRow.Delete End If Thanks a lot, DJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotal "grand total" populates at top of data | Excel Discussion (Misc queries) | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
"Last Cell" to find last row, but can't delete blank rows | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Linking two "total" pages to create a "Complete Total" page | Excel Worksheet Functions |