PC Review


Reply
Thread Tools Rate Thread

Deleting entire row if cell contains "value" - how to review everytime?

 
 
V
Guest
Posts: n/a
 
      16th Aug 2008
Hi~

I found this great macro which works perfectly on my dataset to delete
the entire row if a cell value in column A contains a certain word.

What I would like is to add a code which lets me review and hit accept/
decline every time it cycles through. What kind of code would I add to
it?

Thanks!


' *** delete if a cell contains "xxx" ***

Sub DeleteRelay()
Dim c As Range
With Activesheet.Range("A:A")
Do
Set c = .Find("xxx", LookIn:=xlValues, lookat:=xlPart, _
MatchCase:=False)
If c Is Nothing Then Exit Do
c.EntireRow.Delete
Loop
End With
End Sub

' *** ***
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Microsoft Excel Misc 2 8th Aug 2008 01:54 AM
ReVIEW (Erratum): some shortcut keys not working anymore-----help""""""""PhpApach...WORK WELL!!!! wbrowse@gmail.com Windows XP Help 0 13th Apr 2007 12:29 PM
Disabling "Entire &row/&column" in Delete/Insert Cell Gap Microsoft Excel Programming 1 6th Mar 2005 03:42 PM
How to "install" a checkbox into a cell, then copy it to the entire column...???? (new user to excel) niteowl Microsoft Excel New Users 1 22nd Nov 2004 07:35 AM
"End program - wupdater.exe" pops everytime I shut down? It says I "will lose all unsaved info..." Any suggestion on how to correct this? =?Utf-8?B?VHk=?= Windows XP Help 1 14th Apr 2004 11:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:14 PM.