Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste problem
I know this is simple, but how do I shift the paste of dRange down 1
row? I'm pretty sure I need to use offset somewhere but I can't figure out where. LC = Lastcol(WB2.Sheets(2)) + 1 Set sRange = WB1.Columns("A:M") Set dRange = WB2.Sheets(2).Columns(LC) sRange.Copy dRange Thanks, -- Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste problem
dRange.Offset(1)
HTH Otto "Dan R." wrote in message ups.com... I know this is simple, but how do I shift the paste of dRange down 1 row? I'm pretty sure I need to use offset somewhere but I can't figure out where. LC = Lastcol(WB2.Sheets(2)) + 1 Set sRange = WB1.Columns("A:M") Set dRange = WB2.Sheets(2).Columns(LC) sRange.Copy dRange Thanks, -- Dan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste problem
You can copy 'Columns to Columns' or 'Range to Range', but not
'Columns to a Range'. Try something like this: Set sRange = WB1.Range("A1:M10") Set dRange = WB2.Sheets(2).Cells(2, LC) sRange.Copy dRange Hth, Merjet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste problem
That's right, thanks merjet.
-- Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste problem in vb | Excel Discussion (Misc queries) | |||
Copy/Paste Problem | Excel Worksheet Functions | |||
VBA Copy Paste Problem | Excel Programming | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy/Paste Problem | Excel Programming |