cutting and pasting row in other sheet if cell is empty

[flunzy]

Hi guys,

I'm trying to copy a row to a other sheet when the cell is empty. I've created the code below but it doesn't work and also doesn't give me an error.

Please Login or Register  to view this content.

Does someone has an idea or an another approach to get result???

Thanks in advance

[nathansav]

activecell.value="", you are comparing the cell object to be ""

[flunzy]

activecell.value="", you are comparing the cell object to be ""

Thanks for your respons. Is it possible to place an example of how it should be?

[AB33]

Please Login or Register  to view this content.

.
Could be done in a different way, but need to see a sample.

[nathansav]

If cell.value="" then