I have the following code in a macro and when it is run I get a Run Time Error 438 Object doesn't support this property or method. This occurs at the first occurrance of the destination/source. Any suggestions?
Please Login or Register to view this content.
Last edited by lj123; 11-13-2008 at 01:30 AM.
A window doesn't have a Range propery.
Maybe something like ...
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
This is her macro with your correction. It requires cells from Sheet1 in Book1.xls be copied to Sheet1 in Book2.xls. But I get an error on Book2.xls when I try to run it. (Application error '1004')
Both sheets are open when the code is run.Please Login or Register to view this content.
Last edited by JBeaucaire; 11-12-2008 at 10:16 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This code seems to work for me, no errors. Both workbooks open:
Please Login or Register to view this content.
Ugh. I really have use for this myself and I can't make it work. I installed it exactly as shown and I get a runtime error '9' Subscript out of range on the line:
Please Login or Register to view this content.
Thanks everyone. I was able to get your original code JBeaucaire to work. I originally had trouble because my sheets weren't named Sheet1. But once I cleared those little details up it worked great. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks