| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting rows
i want a program that finds the last entry in column a and deletes all the
rows below it up to row 29 starting 5 rows below the last entry if ("b29") is the value of the row i want to start deletine, why doesnt this work?... x = Range("b35") Rows("y:29").Delete i probably need a 'For Each c In Rows("5:29").Cells' statement or something... any help? thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
deleting rows
Try this
Dim lr As Long lr = Range("A" & Rows.Count).End(xlUp).Row Rows(lr + 5 & ":29").Delete -- Regards Ron de Bruin http://www.rondebruin.nl "lawson" wrote in message ... i want a program that finds the last entry in column a and deletes all the rows below it up to row 29 starting 5 rows below the last entry if ("b29") is the value of the row i want to start deletine, why doesnt this work?... x = Range("b35") Rows("y:29").Delete i probably need a 'For Each c In Rows("5:29").Cells' statement or something... any help? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
| Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
| Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
Linear Mode
