Macro issue deleting input data

I need to write a macro that clears the contents within a row if the first input into the row is a zero. The part I am strugling with is excel is receiving the input row from a scale, and is inputting the row one cell at a time. My macro reads the first input as a zero, clears the contents of the row, but does so before the rest of the information is input into the row. This causes me to end up with a blank first cell, and the rest are filled up with another number. I tried using the wait command, but the same issue occurs. Is there a way I can not make the macro activate until the enter key is pressed? or possibly a way of waiting until the row is done having information input into it before it is cleared?

Much thanks

Tayloe Compton

You should post a small sample of your code or better yet an example workbook.

Please Login or Register  to view this content.