Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete find "Grand Total"
That is because your have the offset(1,0) which is going to the row below
the grand total so you are only deleting the 3 rows under Grand Total and not the row with the Grand Total. Take out the offset and change the resize to 4,1 since you actually want to delete 4 rows total. Sue "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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal "grand total" populates at top of data | Excel Discussion (Misc queries) | |||
"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 | |||
Delete find "Grand Total" | Excel Programming |