Excel VBA to run global search/replace on close event?

[TomYC]

I have a file with numerous worksheets. Every time I add new, imported data to the file, I must run a search and replace on one or more columns in one or more worksheets, or else my data is not "cleaned." I would like to automate this in case I forget!
Surely there is an OnClose event in which all cells in worksheets could be selected, and a search and replace operation run that strips off some unnecessary text strings, after which the file is saved, or even as part of the save process.
I have experimented with macros, would prefer code idea...
Thanks--
T.Y.

 

[SkipVought]

hi,

Please post VBA questions in forum707.

There are many Workbook Events that can be used for sheets in the workbook. You could consider the Workbook_SheetDeactivate event, Workbook_SheetChange event, Workbook_BeforeClose event just to name a few.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]