Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste ranges with offset Excel 2000
Hello,
I¨m working with copyinf and pasting cell in differents sheets, and ait works well but when I try to do the same with range I have problems. I use this code. ------------------------------- Range("B2").Select Do If IsEmpty(ActiveCell) = False Then ActiveCell.Offset(1, 0).Select End If Loop Until IsEmpty(ActiveCell) = True ActiveCell.Value = Workbooks("ReportRP.xls").Sheets("PS").Range("D13: D15") ActiveCell.Offset(0, -1) = _ Workbooks("ReportRP.xls").Sheets("PS").Range("I6:I 10") ____________________________________ the same code refering only to one cell works well, I think the problem is the Offset, can I change it??. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Ranges and Offset | Excel Worksheet Functions | |||
Using Offset with named ranges | Excel Worksheet Functions | |||
Ranges using offset | Excel Programming | |||
Different passwords to separate ranges in excel 2000 | Excel Programming | |||
How do I copy and paste ranges from VB 6.0 in an Excel spreadsheet? | Excel Programming |