The question is if you search a Range of cells like A1:D100 will other
numbers get changed that shouldn't. Rick's code can be changed easily to
open all the workbooks in the folder. If the incorrect ce3lls may get
changged then you have to be more specific about the range of cells you are
changing.

"Kiba" wrote:

1) Its all the workbooks in a folder.
2) They are most likely several places in the workbook, and its going to be
different places in each workbook.

Also the number is probably in a cell with other text.


"Joel" wrote:

1) Where are the workbooks names? Or do you want to open all the workbooks
in a folder?
2) How do you want to finjd the numbers
a) Are the number in the a certain column, row, or Range of Cells on
each worksheet. Or the number in specific cells (name the cells).

"Kiba" wrote:

I need a macro that can search several workbooks with alerts disabled find a
number say (5-510) in a several cells in several worksheets in each workbook
replace it with a new number say (5-511). Save and close. Also I need to
know which workbooks it changed values in. The name is also in cell c2 on a
Data Entry worksheet.

Thanks for the help.

I've tried several things but couldn't get them to work.