Thread: Problem with (One location = Another location)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon[_2_] Simon[_2_] is offline
external usenet poster
  
Posts: 89
Default 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)
Reply With QuoteReply With Quote