Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a macro to copy a range in one workbook and paste into another workbook
Hi all,
I'm experienced in excel, but not very good with Macros. I am trying to write a macro to copy from 1 workbook into another. Using Window 2K SP4, and MS Office 2k SR1 So far I have only this using the Macro Recorder: Sub ITHDdocID() ' ' ITHDdocID Macro ' Macro recorded 25/06/2004 by husky101 ' ' Windows("ITHD Reports.xls").Activate Range("A6").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Windows("ITHD Monthly Calculator for reports V5.xls").Activate ActiveSheet.Paste Range("B3").Select End Sub When I run this macro I receive a 'Subscript out of range error', on line 5 the destination wkbk. I need to copy an unkown range down from ITHD!A6 from wkbk (ITHD Reports.xls) and paste into wkbk2 (ITHD Monthly Calculator for reports V5.xls) into sheet Time!A3 Any assistance will be greatly appreciated. Cheers Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy a range of cells and paste into a new workbook in differentcolumns | Excel Discussion (Misc queries) | |||
Macro to copy/paste from one workbook to another | Excel Discussion (Misc queries) | |||
Macro to Copy / paste from 1 workbook to another | Excel Discussion (Misc queries) | |||
macro to copy and paste into another workbook | Excel Discussion (Misc queries) | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming |