Re: $$Excel-Macros$$ Find value in Active Cell in another sheet(s) & delete

Hi Guys Thanks for that - magic. I understand now how it works. Thanks Charlie On Jun 5, 12:04 pm, "STDEV(i)" wrote: > Dear GoldenLance, > > Thank you very much for your great sugestion.. > > user just *selects/activates a cell* where the criteria is written, and run > the macro... > > kindes

Re: $$Excel-Macros$$ Find value in Active Cell in another sheet(s) & delete

Dear GoldenLance, Thank you very much for your great sugestion.. user just *selects/activates a cell* where the criteria is written, and run the macro... kindest regards, STDEV(i) On Sat, Jun 4, 2011 at 5:57 PM, GoldenLance wrote: > Just a minor tweak to STDEV(i)'s code. Based on the origina

Re: $$Excel-Macros$$ Find value in Active Cell in another sheet(s) & delete

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)" wrote: > please check and try this VBA code if it helps > > Sub DoSomething() > *   ' siti Vi* >    Dim w As Workshee

Re: $$Excel-Macros$$ Find value in Active Cell in another sheet(s) & delete

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

$$Excel-Macros$$ Find value in Active Cell in another sheet(s) & delete

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 -- --