Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone,
I seem to be stuck again with a problem that probably is very easy. The data in my sheet is spread over 7 Columns and about 200-300 Rows. I want to loop through column 7 and delete the entire row if the value is different to 6 possible values. So if the value in column 7 is different from for example 428, 491, 492, 493, 495 and 496 then the entire row should be deleted. I have tried putting these values in an array and do a comparison. That didn't work out. Neither did a comparison with 5 OR's. Hope this is understandable, please let me know if you want to see the code I've used. Thanks for your help KJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |