| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem copying a range to a different workbook
I can't get this to work at all, could someone tell me what's wrong
with this? Workbooks(strHCW).Worksheets("Agn").Activate ActiveWindow.WindowState = xlMaximized Workbooks(strHCW).Worksheets("Agn").Range("$A$1", "$A$1").Select Selection.Copy ActiveWindow.WindowState = xlMinimized Workbooks(strOutput).Worksheets("DataDumpCir").Act ivate activeWindow.WindowState = xlMaximized Workbooks(strOutput).Worksheets("DataDumpCir").Ran ge("$A$6","$A$6").Select Workbooks(strOutput).Worksheets("DataDumpCir").Ran ge("$A$6","$A$6").Paste thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem copying formula from one workbook to another | Excel Discussion (Misc queries) | |||
| Problem copying formula to range of cells | Setting up and Configuration of Excel | |||
| Problem copying from one workbook to anoth | Excel Programming | |||
| Problem copying range and pasting to multiple sheets | Excel Programming | |||
| Copying a Filtered Range from a Sheet in another Workbook | Excel Programming | |||
Threaded Mode
