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