The currentRegion will change from transmittal to
transmittal depending on the amount of rows one uses to
list their drawings being sent out. the people using this
will click on a macro button labeled "LOGIT" and have VBA
do all the rest after they fill out their transmittal.
Most using this do not know VBA and little know Excel.
-----Original Message-----
Instead of using ("D23, Range D23
(xldown).Address).end

Why not try

Range("d23").CurrentRegion.Copy


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

.