Did you try Bob's version?


Gord

On Fri, 15 Aug 2008 09:30:27 -0700 (PDT), Simon
wrote:

On Aug 15, 5:05*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Correct the spelling error and try again.

Gord Dibben *MS Excel MVP

On Fri, 15 Aug 2008 07:45:36 -0700 (PDT), Simon
wrote:



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.Offse*t(7,
0)- Hide quoted text -

- Show quoted text -

Hi Gord,

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

Still an issue though.