Sorry for the late reply. Thank you to all who helped me with this little
problem. I had trouble with the next row thing and followed all your advice.
I've also experimented with this. I found out that the code will check if the
cell above it is blank or not. So I found a solution involving the count
formula. Again, thanks to all of your advice. More power to OfficeKB and all
the members. :)

--
Message posted via http://www.officekb.com