Very clear explanations, thanks Carim!

I have everything working the way I want it to now, with the exception
of the "scan area". I am using the Lcol and Lrow statement you
originally gave me, but for some reason the macro is on "scanning"
columns D & E. My spreadsheet does have a small amount of data (both
text and numeric) in columns F through I. The macro is just ignoring
it.

Is it possible for spreadsheet formatting or data validation (or
somthing else) to hinder the macro or the Lcol statement?


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=518793