| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range using offset range value
Hello,
THe following code works on Excel 2002 but seems to fail on another computer with Excel 2003 Dim TargetCell1 As Range Set TargetCell1 = Range("TargetCell1") Range(TargetCell1, TargetCell1.Offset(Range("MaxNoTerritory").Value, 0)).Copy Range("TargetDisplayCell1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False The error message is Run-time error '-2147417848 (80010108)': Method 'PasteSpecial' of object 'Range' failed and in the debug the following appears Range("MaxNoTerritory").Value = Method 'Range' of object'_Global' failed Can you help? Thanks in advance -- caroline |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
| How to apply OFFSET as the range in a basic 'Copy' process... | Excel Discussion (Misc queries) | |||
| Create/copy combo boxes in one range if condition is met in a different range | Excel Programming | |||
| Problem with Range.Cells.Offset and Range.Cells( row + offset, column) | Excel Programming | |||
| Select and Copy Range using Offset | Excel Programming | |||
Threaded Mode
