Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a macro that copies a range from one workbook, opens another workbook,
selects a sheet and then pastes it. Part of the code looks like this: ChDir "C:\" Workbooks.Open Filename:="C:\Temporary.xls" Sheets("Sizes").Select Range("A3").Select ActiveSheet.Paste It used to work. I can say that what I have changed is that I created a Change Event in the Workbook called "Temporary". Is it getting confused by that somehow? Thank you for your help. -- David P. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I got this problem run-time error 1004 application defined ... | Excel Discussion (Misc queries) | |||
Application-defined or object-defined error Please Help | Excel Discussion (Misc queries) | |||
Compile error in my Application | Excel Discussion (Misc queries) | |||
Macro error : Application-defined or object-defined error | Excel Discussion (Misc queries) | |||
Open Application Error? | Setting up and Configuration of Excel |