Just a minor tweak to STDEV(i)'s code. Based on the original subject, I might change sCriteria = "MyCriteriaText" to sCriteria = ActiveCell.Value
On Jun 4, 2:24 pm, "STDEV(i)" <setiyowati.d...@gmail.com> wrote: > please check and try this VBA code if it helps.... > > Sub DoSomething() > * ' siti Vi* > Dim w As Worksheet, xCel As Range > Dim sCriteria As String > > sCriteria = "MyCriteriaText" '<< please edit > For Each w In Worksheets > If Not w.Name = ActiveSheet.Name Then > If Not LCase(w.Name) = "home" Then > For Each xCel In w.UsedRange > If xCel.Value = sCriteria Then xCel.Clear > Next xCel > End If > End If > Next w > End Sub > > > > > > > > On Sat, Jun 4, 2011 at 11:47 AM, sswcharlie <swch...@gmail.com> wrote: > > Hi > > Part of a another code - > > I want to find the value(text) in active cell (value changes often) in > > workbook (except current WS and one other worksheet 'home") and > > delete. Could be more than one instance. > > > Thanks > > Charlie -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
