how to delete the row if index is known

[hotmalepiyush]

i know the index of the row i want to delete the row and move to the cell below it and run this for loop till the last cell in the cloloumn... i am using the code given below.. please tell me what is wrong

Please Login or Register  to view this content.

[chergh]

Replace:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[mudraker]

hotmalepiyush


Please take a couple of minutes and read the Forum Rules then wrap your VBA code (Rule 3)

You have previously been asked to read & follow the forum rules

If you agree to following the rules please wrap your VBA code and reply to this thread that you agree to follow the rules

[hotmalepiyush]

i did try to put tags for code... in some sites u dont have to type the end tag if thats the last thing in the post so i did not type[/] tag... i will follow from hereafter

[mudraker]

hotmalepiyush

thanks for wrapping your VBA code & replying

chergh's reply has been restored

[hotmalepiyush]

i changed the code... the code is now giving different results depending on which coloumn the active cell is when i run it

i want a code which runs from D5 to the last cell in that coloumn that has some value.. n delete all rows that do not have EQ as value in that coloumn.
plz suggest why i m not getting the desired result.

piyush

[mudraker]

When deleteing rows it is best to work in reverse - starting at the last row and working down to row 5

The reason for this is when you delete a row the next row becomes the row you just deleted

e;g
Your macro is looking at d12
Delete row 12, row 13 becomes the new row 12
Your macro was looking at the old d12 and does not look at the new d12 then with the next loop moves on to the new d13

try

Please Login or Register  to view this content.

[chergh]

Try using this instead:

Please Login or Register  to view this content.

[hotmalepiyush]

thanx a lot