Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranged, help please
Cell E3 is called "Latest"
In this column I offset to paste vlaues in from other sheets intop the relvant ow (determined by the offset - could you Lookup I guess). However do I need to Dim the range to ge tthe following to work? MyWBAccRep.Sheets("Volumes").Range("Latest").Copy Destination:=Range("Latest").Offset(0, 1) Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranged, help please
Named ranges are not part of a workbook but part of the application level of
a workbook. Try this from MyWBAccRep.Sheets("Volumes").Range("Latest").Copy to MyWBAccRep.application.Sheets("Volumes").Range("La test").Copy "Simon" wrote: Cell E3 is called "Latest" In this column I offset to paste vlaues in from other sheets intop the relvant ow (determined by the offset - could you Lookup I guess). However do I need to Dim the range to ge tthe following to work? MyWBAccRep.Sheets("Volumes").Range("Latest").Copy Destination:=Range("Latest").Offset(0, 1) Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranged, help please
You need to be explicit with your references. You are good on the copy but
you are not explicit on your destination... With MyWBAccRep.Sheets("Volumes").Range("Latest") .Copy Destination:=.Offset(0, 1) end with What you have is equavalent to MyWBAccRep.Sheets("Volumes").Range("Latest").Copy Destination:=Activesheet.Range("Latest").Offset(0, 1) so if Latest is not on the active sheet it will bomb... -- HTH... Jim Thomlinson "Simon" wrote: Cell E3 is called "Latest" In this column I offset to paste vlaues in from other sheets intop the relvant ow (determined by the offset - could you Lookup I guess). However do I need to Dim the range to ge tthe following to work? MyWBAccRep.Sheets("Volumes").Range("Latest").Copy Destination:=Range("Latest").Offset(0, 1) Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranged, help please
I think you are mistaken. Range names are either tied to the Workbook for
global named ranges or to the worksheet for local named ranges. The Object Model is Application - Workbooks - Worksheets The appliation contains 0 or more workbooks. A Workbook contains 1 or more worksheets. A workbook can not contain an application. If you check the value of Thisworkbook.Application and ThisWorkbook.Parent you will see that they are both the same. -- HTH... Jim Thomlinson "Joel" wrote: Named ranges are not part of a workbook but part of the application level of a workbook. Try this from MyWBAccRep.Sheets("Volumes").Range("Latest").Copy to MyWBAccRep.application.Sheets("Volumes").Range("La test").Copy "Simon" wrote: Cell E3 is called "Latest" In this column I offset to paste vlaues in from other sheets intop the relvant ow (determined by the offset - could you Lookup I guess). However do I need to Dim the range to ge tthe following to work? MyWBAccRep.Sheets("Volumes").Range("Latest").Copy Destination:=Range("Latest").Offset(0, 1) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named ranged selection problem | Excel Worksheet Functions | |||
Adding Named ranged for each column... | Excel Programming | |||
Changing a named ranged based on array size on a form | Excel Programming | |||
Vlookup - Using a named ranged for col_index_num | Excel Discussion (Misc queries) | |||
Counting in ranged intervals | Excel Programming |