Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This might need a little tweak but should put on the right path:
< your code ActiveCell.EntireColumn.Select Selection.Insert Shift:=xlToRight *'need code to paste sh1.range("c1:c120") into inserted column here* '=========== my code COL = ActiveCell.Column Cells(1, COL).Select Filename = "File Name to open??" ThisSheet = ActiveWorkbook.ActiveSheet.Name Set BaseBook = Application.ActiveWorkbook.Name Set SourceBook = Workbooks.Open(Filename) SourceTab = SourceBook.Worksheets("Sheet1").Index Set SourceRange = SourceBook.Worksheets("Sheets1").Range("C1:C120") SourceRcount = SourceRange.Rows.Count Set DestRange = BaseBook.Worksheets(ThisSheet).Cells(1, COL) SourceRange.Copy DestRange SourceBook.Close False Hope this helps Glen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying workbooks | New Users to Excel | |||
copying workbooks | Excel Worksheet Functions | |||
Copying from other Workbooks | Excel Discussion (Misc queries) | |||
need help for copying among workbooks | Excel Programming | |||
Copying from several workbooks into one | Excel Programming |