Why don't you record a macro doing a simple Find/Replace on the whole
worksheet?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lindsey M" wrote in message
...
Hi

I have a report that comes with all kinds of surplus information that I am
trying to get rid of so I am left with the best bits. What I want to do is
do
a macro to delete the words that are not needed, eg

- Evaluation Overview Report (this is the same throughout whole report)
- Generated: Mar 03 2005 16:15:12 <--- will change
- Quality: 64% <--- will change

etc etc

In the above the 1st will always be that but there are some that will be
different depending on when the report was run, the quality percentage and
so
on

There are about 20 odd things that are duplicated possibly 300 times on
each
page that I need to clear because what I will then do is delete all the
blank
rows which will leave me with the data that I want. I can't take out the
same
rows/columns at the start because they are not concurrent.

Any ideas on where to start on this? Any code snippets would be very
welcome!

Cheers in advance
Linds