Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > Problem using Copy:=Destionation across different workbooks
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 89
Default Problem using Copy:=Destionation across different workbooks
What is wrong with

MyWBRBS.Range("I4").End(xlDown).Copy
Destination:=MyWBAccRep.Sheets("Volumes").Cells.Fi nd("latest").ActiveCell.Offset(7,
0)

Thanks
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 89
Default Problem using Copy:=Destionation across different workbooks
On Aug 13, 5:02*pm, Simon wrote:
What is wrong with

MyWBRBS.Range("I4").End(xlDown).Copy
Destination:=MyWBAccRep.Sheets("Volumes").Cells.Fi nd("latest").ActiveCell.O*ffset(7,
0)

Thanks

MyWBRBS only has 1 worksheet so it is ok to omit Sheets("RBS")
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 5,939
Default Problem using Copy:=Destionation across different workbooks
No it's not ok to omit the sheet. The parent of a range is a sheet and not a
workbook. You will get a object or method not defined error...
--
HTH...

Jim Thomlinson


"Simon" wrote:

On Aug 13, 5:02 pm, Simon wrote:
What is wrong with

MyWBRBS.Range("I4").End(xlDown).Copy
Destination:=MyWBAccRep.Sheets("Volumes").Cells.Fi nd("latest").ActiveCell.OÂ*ffset(7,
0)

Thanks

MyWBRBS only has 1 worksheet so it is ok to omit Sheets("RBS")

Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 5,939
Default Problem using Copy:=Destionation across different workbooks
You do not want to use find directly in that statement. If latest is not
found then your code will crash. Additionally you have not specified the
prameters of the find so it will use whatever parameters the user had last
set. Please check your earlier posts for replies...
--
HTH...

Jim Thomlinson


"Simon" wrote:

What is wrong with

MyWBRBS.Range("I4").End(xlDown).Copy
Destination:=MyWBAccRep.Sheets("Volumes").Cells.Fi nd("latest").ActiveCell.Offset(7,
0)

Thanks

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
copy between workbooks Carmela Excel Worksheet Functions 3 January 8th 10 08:24 PM
Copy/ move selected data from workbooks to seperate worksheets or workbooks Positive Excel Worksheet Functions 1 August 30th 07 04:54 PM
problem with Linking workbooks via "copy" and "paste link" Arkitek Excel Discussion (Misc queries) 0 December 19th 06 10:03 PM
Copy between workbooks Wolfie Excel Programming 8 March 15th 06 09:08 PM
copy and paste with 2 different workbooks problem bigdaddy3 Excel Worksheet Functions 4 September 22nd 05 01:06 PM


All times are GMT +1. The time now is 09:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement