how to avoid null/double click

Hi there, the below event macro creates a line above the cell entry in column A.

It also creates a line if i double click in cell which i don not want. I just want a line to be created if a number entered in any cell of column A

Could some one help me..thanks-var

Please Login or Register  to view this content.

Try this:-

Please Login or Register  to view this content.

Thanks very much Mike..It works..

Have a great day--var