Find and Replace only one instance.

[MarcSF]

Hello I am trying to replace only one instance of a value in a sheet which is always 8 cells over from another value. (I have hundreds of these sheets so I have some code for that loop task).

Trick is there are multiple entries of each value and it is not always in the same cell of each sheet but it is always a relative 8 cells over from the first instance of another value.
I imagine it would go like this:


Go to cell A1
Search by column until you find the first "9999" in the sheet.
Now move 8 columns over, (same row) and replace whatever is in that cell with "8888"
Stop (dont look for any more "9999"s)
Save/close file


Trickier than I can handle Thx as always!

[PCI]

Is the job to be done in several sheets ?
IS there always 8 columns over the target cell else what to do ?
Can you send a short excel sample to avoid bad understanding

[PCI]

Is it what you need ???

Please Login or Register  to view this content.

[PCI]

My understanding was not correct I think, here a remake
Same job for all sheets

Please Login or Register  to view this content.

[MarcSF]

No only one sheet per workbook but 100s of workbooks

FandR1.JPG

[PCI]

Where are all workbooks?
Only a particular sheet to treat per workbook

[PCI]

Where are all workbooks?
Only a particular sheet to treat per workbook

[MarcSF]

Hello this seems to work unless I change the 9999 and 8888 examples to my actual values of "1-415-506-3232" and "Remove"

[PCI]

Please send an Excel sample to show when it fails
See my test file attached

[MarcSF]

Was just the quotes I guess! Thanks so much!

[PCI]

Was just the quotes I guess

Yes usual error
But the story of the 100 workbooks to treat is not solved for me ...no ?