Problem with (One location = Another location)
 

RBS.Sheets("RBS").Range("I4").End(xlDown).Copy
Destintion:=AccRep.Sheets("Volumes").Cells.Find("l atest").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("l atest").ActiveCell.Offset(7,
0)

Problem with (One location = Another location)
 

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)

"Simon" wrote in message
...
RBS.Sheets("RBS").Range("I4").End(xlDown).Copy
Destintion:=AccRep.Sheets("Volumes").Cells.Find("l atest").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("l atest").ActiveCell.Offset(7,
0)

Problem with (One location = Another location)
 

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.Offset(7,
0)

Problem with (One location = Another location)
 

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.

Problem with (One location = Another location)
 

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.

Problem with (One location = Another location)
 

It certainly worked in my tests.

--
HTH

Bob

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

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...

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.

Problem with (One location = Another location)
 

On Aug 15, 7:10*pm, Gord Dibben <gorddibbATshawDOTca wrote:
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.- Hide quoted text -

- Show quoted text -

Thanks Gord, works fine :-D