Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xldown and xlright
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
xldown and xlright
Instead of using ("D23, Range D23
(xldown).Address).end Why not try Range("d23").CurrentRegion.Cop -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
xldown and xlright
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use xldown to select a range of cells | Excel Discussion (Misc queries) | |||
End(xlDown) not working? | Excel Discussion (Misc queries) | |||
(xlDown) not working properly! | Excel Programming | |||
(xlDown) not working properly! | Excel Programming | |||
Selection.End(xlDown) with Rows selected | Excel Programming |