Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello
I got a macro to fix, which has worked. The original code was: Columns("M:M").Select Selection.Cut Range("L1").Select ' was L1 Selection.Insert Shift:=xlToRight I tried this also: Range("L1").Select DoEvents Range("L1").Insert and both gives the error: Runtime error 1004 Insert method of Range class failed. What can cause this? WBR Sonnich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem in inserting rows | Excel Discussion (Misc queries) | |||
Cutting rows in excel | Excel Discussion (Misc queries) | |||
Cutting rows and inserting in another sheet | Excel Discussion (Misc queries) | |||
Reference Problem w/ inserting rows | Excel Discussion (Misc queries) | |||
Problem encountered when cutting and pasting | Excel Discussion (Misc queries) |