Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying an entire column
I am copying info from a group of cells from one workbook to anothe workbook as shown below, but I have a lot of cells to copy. Is i possible to shorten this up by copying entire columns rather than on cell at a time or possibly even an entire group of columns and rows? Dim BNDL1 As String Dim BNDL2 As String Dim BNDL3 As String BNDL1 = Range("A4").Value BNDL2 = Range("A5").Value BNDL3 = Range("A6").Value Windows("VERCO.xls").Activate With Worksheets("BOM") .Cells(19, 1).Value = BNDL1 .Cells(20, 1).Value = BNDL2 .Cells(21, 1).Value = BNDL3 End Wit -- dl ----------------------------------------------------------------------- dlb's Profile: http://www.excelforum.com/member.php...fo&userid=1648 View this thread: http://www.excelforum.com/showthread.php?threadid=52286 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying conditional formatting to an entire column in Excel 2007 | Excel Worksheet Functions | |||
Copying entire row | Excel Programming | |||
Copying an entire row or Rows based on column criteria | Excel Programming | |||
copying conditional formatting to an entire column | Excel Discussion (Misc queries) | |||
copying entire column | Excel Programming |