Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste Range
I have a range (E10:P95) and I would like to have excel copy it and
paste the values in a range of identical size (U10:AF95). Can someone please tell me how to do this. I have tried using these codes: Range("E10:P95").Copy Range("U10:AF95").Paste Range("E10:P95").Select Selection.Copy Range("U10:AF95").Select Selection.Paste Neither one works for whatever reason, and cause my macro to skip sections. Does anyone know how to solve this problem? Any help would be appreciated. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste Range
should be all you need, but qualify the range with the sheet names
Range("E10:P95").Copy Range("U10") or Worksheets("sheet1").Range("E10:P95").Copy Worksheets("sheet1").Range("U10") -- Gary "mastermind" wrote in message ps.com... I have a range (E10:P95) and I would like to have excel copy it and paste the values in a range of identical size (U10:AF95). Can someone please tell me how to do this. I have tried using these codes: Range("E10:P95").Copy Range("U10:AF95").Paste Range("E10:P95").Select Selection.Copy Range("U10:AF95").Select Selection.Paste Neither one works for whatever reason, and cause my macro to skip sections. Does anyone know how to solve this problem? Any help would be appreciated. Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste Range
When you do a Copy & Paste (without VBA), you select only one cell before
the Paste operation. I recorded a macro as I did a Copy&Paste; this is what I got Sub Macro1() '' Macro1 Macro ' Macro recorded 22/12/2006 by Bernard V Liengme Range("B2:B5").Select Selection.Copy Range("J2").Select '<<<<<< Note only one cell is selected ActiveSheet.Paste End Sub best wishes and Merry Christmas -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mastermind" wrote in message ps.com... I have a range (E10:P95) and I would like to have excel copy it and paste the values in a range of identical size (U10:AF95). Can someone please tell me how to do this. I have tried using these codes: Range("E10:P95").Copy Range("U10:AF95").Paste Range("E10:P95").Select Selection.Copy Range("U10:AF95").Select Selection.Paste Neither one works for whatever reason, and cause my macro to skip sections. Does anyone know how to solve this problem? Any help would be appreciated. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy & paste range | Excel Discussion (Misc queries) | |||
copy range and paste into every 3rd cell of new range | New Users to Excel | |||
copy and paste values in a range | Excel Programming | |||
Copy paste range | Excel Programming | |||
copy / paste values for certain range | Excel Programming |