Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm pretty new to working with VB, so excuse me if this is just something simple I have overlooked. I have a fairly simply macro that moves all the Cells in a range down the sheet by 1 (by cutting and pasting). This initially seemed to work, but now i get a "Method 'Paste' of object '_Worksheet' failed" error when I run it. This is the full macro: Range("L1:AH500").Select ActiveWindow.ScrollColumn = 4 ActiveWindow.ScrollRow = 1 Application.CutCopyMode = False Selection.Cut Range("L2").Select ActiveSheet.Paste Range("I2:I24").Select Selection.Copy Range("L1:AH1").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True If anyone can help me, please do! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
"method 'Copy' of object '_Worksheet' failed" | Excel Programming | |||
Method 'Paste' of object '_Worksheet' failed | Excel Discussion (Misc queries) | |||
Method 'Paste' of object '_worksheet' failed | Excel Programming | |||
METHOD "SELECT" OF OBJECT '_WORKSHEET' FAILED when opening a file | Excel Programming |