Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cut and return
i have this simple code.
all it does is cut the selection copy it on another page and return to the original page. when back in the original page it should delete the empty row that is left from the cut. it does the job but is giving me debug error. Sub updated() Selection.Cut Sheets("Sheet2").Select Rows("1:1").Select Selection.Insert Shift:=xlDown Sheets("sheet1").Select Selection.Delete.Row End Sub ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return date if in range, else return blank | Excel Worksheet Functions | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
VBA Syntax for VLOOKUP to return array of return values | Excel Programming |