View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steved Steved is offline
external usenet poster
 
Posts: 519
Default Find and replace in every folder.

From Steved

I forgot to mention it is in Col A:A only

Thankyou.

"Steved" wrote:

Hello from Steved

Can this be done please.

Find 4001 and replace with 4101

I've a folder named Mon-fri ( 74 folders )

Is it possible to use Find and Replace, have it look in all the 74 Folders,
find 4001 and replace with 4101, also look in the Sheet2, as some folders
have 2 worksheets.

Thankyou.