xldown and xlright

[He4Giv]

Hello...I have a tranmittal on a worksheet tab
named "transmittal" and I need to log the drawings sent or
listed to a "Transmittal Log" worksheet tab every time we
fill out a new transmittal.
the range of info I need is in Cells D23:G36 (4 columns
wide) on the "Transmittal" worksheet. Sometimes only rows
23,24 may be filled in, other times 23,24,25,26 may be
filled in and so on. I used range ("D23, Range D23
(xldown).Address).end to have the cursor start in D23 and
go down till it hits a blank row but im not sure how to
tell VBA to hilite it across to column G. Column D is
labeled "Quantity", E is labeled "Dwg. No.", F is
labeled "Drawing Description", and F is labeled "Dated".
Once the appropiate cells are hilited it will be copied to
the Transmittal Log worksheet tab on the next available
row down. I forget how to tell VBA how to go to Column A
on the transmittal log worksheet and xldown to it hits the
next blank row in column A.
the next time someone uses this transmittal for different
drawings it will then have to be logged also to the log
sheet on the next blank row down.
your help will be appreciated.
God Bless
(e-mail address removed)

 

[mudraker]

Instead of using ("D23, Range D23
(xldown).Address).end

Why not try

Range("d23").CurrentRegion.Cop

 

[He4Giv]

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.