Hi John:

Thanks very much for your advice and the code! The "NewRow" work
perfectly now but I noticed that the text (relatively long) I put i
column D always move 1 line down. I believe it is the length of th
text that cause the problem. I wonder how can I format both the cel
and the text so that they will fit nicely together.

Thanks in advance.

Ale

--
Message posted from http://www.ExcelForum.com