Hi sjsean,
Try the attached workbook.
Put the words No Sales (without the quotes) into any cell on one of the
sheets.
Note that sheet name and then run the macro.
That sheet should be deleted.
Hope this helps.
Regards - Dave.
From: sjsean sjsean95...@gmail.com
To: MS EXCEL AND VBA MACROS
when working down thru a bunch of rows, deleting some according to specific
criteria. I found a solution, but not as elegant as just working up from the
bottom.
Regards - Dave.
Date: Thu, 28 May 2009 04:43:38 -0700
From: schreiner_p...@att.net
Subject: $$Excel-Macros$$ Re: Trouble with find
Hi ,
chk if this works for u
Sub test()
On Error Resume Next
Application.DisplayAlerts = False
Criteria = No Sales
For i = 1 To Sheets.Count
Sheets(i).Select
cellf = Cells.Find(what:=Criteria, after:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows,
-Macros$$ Re: Trouble with find
To: excel-macros@googlegroups.com
you're off to a good start.
However, the .Find function looks for things in the selected CELL.
What you really want is to see if the sheet NAME is No Sales.
Try:'==
Sub