Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
minor modification to macro, need to delete cells
can someone help me add to his macro, after it copys each line I need it to
delete the values in the A Column , E Column and F column, but i cant figure it out.. anyone help would be appreciated. Thanks! Sub CopyToSheetz() Dim rng As Range Dim oCell As Range Set rng = Range("B4:B" & Cells(Rows.Count, "B").End(xlUp).Row) For Each oCell In rng oCell.EntireRow.Copy _ Destination:=Sheets(oCell.Value).Range("A65536").E nd(xlUp).Offset(1, 0) Next oCell End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro - modification | Excel Discussion (Misc queries) | |||
Macro Modification | Excel Worksheet Functions | |||
Macro Code minor alteration please. | New Users to Excel | |||
Need Macro Modification | Excel Programming |