Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to find and delete rows!
I am trying to find and delete specific rows in a spreadsheet, however the reference I=
=E2=80=99m looking for e.g. 800411 is not always going to be in the spreadsheet, so my= macro is not working on all occasions =E2=80=93 any ideas how I can overcome this. Macro so far: = Sheets("top10month").SelectCells.Find(What:=3D"800 411", After:=3DActiveC= ell, LookIn:=3DxlFormulas, LookAt _ :=3DxlPart, SearchOrder:=3DxlByRows, SearchDirection:=3DxlNext, MatchCase:= =3D _ False, SearchFormat:=3DFalse).Activate ActiveCell.Rows("1:1").EntireRow.Select Application.CutCopyMode =3D False Selection.Delete Shift:=3DxlUp ActiveCell.Select = Any help is appreciated this is a great forum for beginners like me! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete pictures with a macro | Excel Discussion (Misc queries) | |||
Can't find macro in an Excel file to delete it | Excel Discussion (Misc queries) | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
Macro data selection line delete | Excel Discussion (Misc queries) | |||
Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) |