Problem with (One location = Another location)

[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)

 

[Bob Phillips]

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)

 

[Gord Dibben]

Correct the spelling error and try again.


Gord Dibben MS Excel MVP

 

[Simon]

Correct the spelling error and try again.

Gord Dibben  MS Excel MVP





- Show quoted text -

Hi Gord,

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

Still an issue though.

 

[Gord Dibben]

Did you try Bob's version?


Gord

Hi Gord,

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

Still an issue though.

 

[Bob Phillips]

It certainly worked in my tests.

--
HTH

Bob

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

 

[Simon]

Did you try Bob's version?

Gord






- Show quoted text -

Thanks Gord, works fine :-D