View Full Version : Urgent help Needed <<removing Rows
alopecito
04-14-2009, 12:23 PM
I just need a quick code that remove the rows that contains "Total Leads", the text will be in column a...See Sample.
Thanks!!
Paul_Hossler
04-14-2009, 12:35 PM
Quickest 'one shot' way is to turn on Data Filter, filter on Totals, highlight and delete the lines.
Paul
mdmackillop
04-14-2009, 12:39 PM
Sub Macro1()
Range("A:A").AutoFilter Field:=1, Criteria1:="Total Leads"
Range("A2:A65536").SpecialCells(xlCellTypeVisible).EntireRow.Delete
Range("A:A").AutoFilter
End Sub
alopecito
04-14-2009, 02:24 PM
Thanks, that will work for now!!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.