| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save problem with location | Excel Programming | |||
| Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
| Macro Location Problem | Excel Programming | |||
| Mouse Location, Movement and Spreadsheet Location | Excel Programming | |||
| Stock Location Sorting Problem | Excel Discussion (Misc queries) | |||
![Simon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
