Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would like to delete rows in column c for a criteria with a macro code. But
I have a problem with my code, it doesn't work. Could anyone tell me what's wrong with my macro code? Thanks! Sub filter() Dim i As integer i=0 Do until i="" 'my criteria is that all rows that contain a value between 800 and 900 have to be deleted If Cells (i,3).Value=800 AND Cells(i,3)<=900 Then EntireRow.delete i=i+1 Loop End sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with code | Excel Discussion (Misc queries) | |||
CODE PROBLEM | Excel Discussion (Misc queries) | |||
VB Code Problem | Excel Discussion (Misc queries) | |||
XLS to CSV Code Problem | Excel Worksheet Functions | |||
Little problem with this code... | Excel Discussion (Misc queries) |