 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / August 2008Problem with (One location = Another location)
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)  SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > RBS.Sheets("RBS").Range("I4").End(xlDown).Copy > Destintion:=AccRep.Sheets("Volumes").Cells.Find("latest").Offset(7, 0) [quoted text clipped - 4 lines] > Destintion:=AccRep.Sheets("Volumes").Cells.Find("latest").ActiveCell.Offset(7, > 0) Correct the spelling error and try again. Gord Dibben MS Excel MVP >RBS.Sheets("RBS").Range("I4").End(xlDown).Copy >Destintion:=AccRep.Sheets("Volumes").Cells.Find("latest").Offset(7, 0) [quoted text clipped - 4 lines] >Destintion:=AccRep.Sheets("Volumes").Cells.Find("latest").ActiveCell.Offset(7, >0) > Correct the spelling error and try again. > [quoted text clipped - 10 lines] > > - Show quoted text - Hi Gord, I'd corrected the spelling (only typo'd on that partuicular example). Still an issue though. Did you try Bob's version? Gord >> Correct the spelling error and try again. >> [quoted text clipped - 16 lines] > >Still an issue though. It certainly worked in my tests. SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Did you try Bob's version? > [quoted text clipped - 24 lines] >> >>Still an issue though. > Did you try Bob's version? > [quoted text clipped - 22 lines] > > - Show quoted text - Thanks Gord, works fine :-D |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.