Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting 2 rows
Hello,
I wonder how to delete 2 rows if there is zero value in the first row? I know how to delete one row with zero value but I do not know how to delete to rows. There are many rows with values. If there is a row with zero value I want to delete the row with zero value and next row with whatever value. I have several thousands rows. example A 1 5 0 DELETE 2 DELETE 2 2 0 DELETE 5 DELETE Thank you very much in advance for help Tomek |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting 2 rows
Use the resize method
activecell.Resize(2).EntireRow.delete -- Regards, Tom Ogilvy "Tomek" wrote in message .. . Hello, I wonder how to delete 2 rows if there is zero value in the first row? I know how to delete one row with zero value but I do not know how to delete to rows. There are many rows with values. If there is a row with zero value I want to delete the row with zero value and next row with whatever value. I have several thousands rows. example A 1 5 0 DELETE 2 DELETE 2 2 0 DELETE 5 DELETE Thank you very much in advance for help Tomek |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting 2 rows
Dnia Sat, 29 Jan 2005 12:18:50 -0500, Tom Ogilvy napisał(a):
Use the resize method activecell.Resize(2).EntireRow.delete Thank you very much , it really works! Tomek |
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 |