Hello Ron From Steved

Ron My objective is to find Stagecoach in Line 1 and replace with NZ Bus

What the below has done to all my Files is A1:AZ1 in each cell in the below
Range it put NZ Bus for example A1, B1 all through to AZ1.

Please How Can I tell The Below Range To Find Stagecoach and Replace with NZ
Bus as it could be anywhere on Row 1 for example Q1 or T1 or W1 or AZ1
Thankyou.

..Range("A1:AZ1").Value = "NZ Bus"


"Ron de Bruin" wrote:

Hi Steved

You can look here
http://www.erlandsendata.no/english/...php?t=envbadac

OR

Try this macro
http://www.rondebruin.nl/copy4.htm

The first example


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steved" wrote in message ...
Hello from Steve Dee

Is it possible please to replace Stagecoach with NZ Bus without having to
open each file. ( Over 650 off them to do )

Thankyou.