Problem with (One location = Another location)

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

Simon

RBS.Sheets("RBS").Range("I4").End(xlDown).Copy
Destintion:=AccRep.Sheets("Volumes").Cells.Find("latest").Offset(7, 0)

It says Object or Method is not supported. I tried this as well

RBS.Sheets("RBS").Range("I4").End(xlDown).Copy
Destintion:=AccRep.Sheets("Volumes").Cells.Find("latest").ActiveCell.Offset(7,
0)
 
RBS.Sheets("RBS").Range("I4").End(xlDown).Copy _
Destination:=AccRep.Sheets("Volumes").Cells.Find("latest").Offset(7, 0)



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Correct the spelling error and try again.

Gord Dibben  MS Excel MVP





- Show quoted text -
Click to expand...

Hi Gord,

I'd corrected the spelling (only typo'd on that partuicular example).

Still an issue though.
 
It certainly worked in my tests.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Problem using Copy:=Destionation across different workbooks 3
Something in this is causing a crash 2
What in the edited code below makes it crash????? 2
Loop to End 0
Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, 2
Macro to fill to next field with data 4
If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
Copy Destination parameter issue 2

Back
Top