Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut Contents and Paste
I am trying to create a macro that will search every cell in Column A for
ZRP3 when it finds these contents cut the entire row it exists in up to column L, and paste all the rows that got copied into a new worksheet. This what I have written so far but its not quite doing the job Sub CutContentsandPaste() Range("A1").Select ActiveCell.FormulaR1C1[-1]= "ZRP3" Range("A:L").Select Selection.Cut Sheets.Add ActiveSheet.Paste End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste contents, but keep formula of destination | Excel Discussion (Misc queries) | |||
Paste or insert data before and after cel contents | Excel Discussion (Misc queries) | |||
Copy and paste contents of one sheet into another | Excel Programming | |||
copy and paste contents of sheet | Excel Programming | |||
paste contents from other spreadsheet | Excel Worksheet Functions |