Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm very new to the Excel copy after method, and I was wondering how I would go about integrating the following code into my module. Would I need to specify the name of the new workbook at some point within the code? I have tried running the following code by itself in a module, but I get the "object required" error. Any ideas? Thanks - Louis == bk.Worksheets(Array("Hourly Timesheets", "dates", "Time Balances")).Copy after:=bk.Worksheets(bk.Worksheets.Count) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Misc Excel Copy Question | Excel Discussion (Misc queries) | |||
Excel 2003 - copy paste question | Excel Discussion (Misc queries) | |||
QUESTION: Copy pivottable from excel file to another. | Excel Discussion (Misc queries) | |||
copy question | Excel Programming | |||
question about - excel macro copy chart to word document | Excel Programming |