Problem using Copy:=Destionation across different workbooks

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

What is wrong with

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

Thanks
 
What is wrong with

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

Thanks
Click to expand...

MyWBRBS only has 1 worksheet so it is ok to omit Sheets("RBS")
 
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...
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Destination parameter issue 2
Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, 2
Problem with (One location = Another location) 6
Something in this is causing a crash 2
Named Ranged, help please 3
What in the edited code below makes it crash????? 2
Can Vba workout if a selection is part of a group? 0
Copying with .Value 3

Back
Top