Maybe a basic question: How to delete rows with a specific value?

		Microsoft Office Forums > Microsoft Excel > Excel
Maybe a basic question: How to delete rows with a specific value?

FAQ

Thread Tools

Display Modes

12-05-2019, 11:43 PM

jolivanes

Windows 10 Maybe a basic question: How to delete rows with a specific value?

Office 2013

Advanced Beginner

Join Date: Sep 2011

Posts: 91

jolivanes will become famous soon enough

Code:

Sub Maybe()
With Sheets("Sheet1").Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row)
    .AutoFilter 1, 0
    .Offset(1).SpecialCells(12).EntireRow.Delete
End With
    ActiveSheet.AutoFilterMode = False
End Sub

Change references where required.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to delete table rows based on the absence of a single specific keyword	JellehFishh	Word VBA	2	06-27-2019 08:23 AM
How to auto-delete rows that contain specific word?	dylansmith	Excel Programming	2	10-15-2018 12:05 AM
Excel VBA macro to copy specific rows and delete it	pourmalla	Excel Programming	2	04-02-2017 12:09 AM
Macro to delete rows not containing specific text	Alimou	Excel Programming	4	02-06-2017 07:35 AM
A basic question I'm sure.	talosian	PowerPoint	0	04-21-2011 05:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:09 AM.