Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have 2 WORKBOOKS - OLD and NEW
Each Workbook is identical but OLD has OLD data which I need to copy to NEW workbook a sheet at a time. (about 40 sheets) I'm trying to copy SELECTED columns from say Oldworkbook sheet 1 to NewWorkbook Sheet 1 etc.. The following code works fine for Columns A:B for example but if I do D:D or C:D I get and error!!! Runtime error: -2147417848 (80010108) Mehtod 'Copy' of object Range failed WHY?? - all I've done is changed the column !! Break shows error at sourceRange.Copy Destination:=destrange at this point it has copied the 1st sheet HELP!!! Code: Sub CopyColumn() Dim newbook As Workbook Dim oldbook As Workbook Dim sourceRange As Range Dim destrange As Range Dim cnum As Integer Dim sht As Long Application.ScreenUpdating = False Set newbook = ThisWorkbook Set oldbook = Workbooks.Open("C:\DATA\OLD.XLS") For skt = 1 To 3 'Sheets.Count - ok limit to 3 sheets for testing Set sourceRange = oldbook.Worksheets(sht).Columns("D:D") Set destrange = newbook.Worksheets(sht).Columns("D:D") sourceRange.Copy Destination:=destrange Next sht oldbook.Close Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
How can I save an editable copy of a protected excel workbook? | Excel Discussion (Misc queries) | |||
how to copy 2350 hyperlink full paths to any column in a worksheet ? | Excel Discussion (Misc queries) | |||
How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) | |||
how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) |