Is This Possible?

[Dazzawm]

I have a folder with 30 files in. Is it possible to use a code to open all files look for a word that will be in column H and then put another word in column K in one fail swoop, rather than opening each file individually? Thanks.

 

[VoG]

Delete the word Private

 

[RSXchin]

read the next one.

 

[RSXchin]

Delete the word Private

Yeah, do that. Sorry.

 

[Dazzawm]

Yes it seemed to be because it was a Private Sub. I changed it to a Public Sub and it worked fine. Thanks for your help.

 

[RSXchin]

sorry, I leave most of my snippets as private so they don't interfere with my "work"