syntax of IF NEXT CELL LOOP

[bopsgtir]

Can someone tell me where im going wrong with the below code, i tried it in two parts so adding the value of the formula works but when i add the if, the whole section of code doesnt seem to work, i know it must be syntax issue but dont know where??

Please Login or Register  to view this content.

[mrice]

No sure what you mean when you say it doesn't appear to work. One thing that I did notice is that you are deleting cells in a range which is being used to drive a loop. It might be better to have a counter instead and work thought the cells in an upwards direction so that deleting does not affect any subsequent rows.

[Norie]

Why not try this?

Please Login or Register  to view this content.