Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I was doing this:
Range("H1:H5").Select Selection.Copy Range("B1:B5").Select ActiveSheet.Paste Application.CutCopyMode = False and then came across this technique which apparently is more efficient: Range("H1:H5").Copy Range("B1:B5") Can you do the same thing when trying to PasteSpecial Values? Is there a more efficient way to do this: Range("H1:H5").Select Selection.Copy Range("B1:B5").Select Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False Can you do something like? Range("H1:H5").PasteSpecialPaste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Range("B1:B5") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Efficient Way of Copy/PasteSpecial of Non-Continuous Range in VBA | Excel Programming | |||
efficient code to copy/paste | Excel Programming | |||
Copy & Paste code more efficient | Excel Programming | |||
More efficient copy/paste?? | Excel Programming | |||
Efficient Copy/Paste | Excel Programming |