for each cell in Range("A1:A30")
if cell.Text = "002" then
Next
also, if you are copying or something:
Perhaps something on this page
http://www.rondebruin.nl/copy5.htm
at Ron de Bruin's site
--
Regards,
Tom Ogilvy
--
Regards,
Tom Ogilvy
"gregory" wrote:
I have a set of data that contains:
- 10 rows that start with 001
- 10 rows that start with 002
- 10 rows that start with 003.
How should the macro be written to find only the rows that start with 002
and copy those to another spreadsheet?