Excel 97
I needed to perform a search and replace - one set of numbers, 600 plus, with another.
I opened a worksheet and typed abc in a cell then started the record a macro – next I used the find and replace option and replaced abc with xyz.
Next I stopped recoding.
I then stepped into the macro and cut and pasted the text to desired number of lines
Replacing abc and xyz with the desired set of numbers
I did a test with 20 lines of the macro and this was ok
I then went on and typed in the rest of the numbers 1200 of them!
Result was some were ok but many generated random numbers some with plus signs.
I checked the macro figures and all were ok
I checked the cell formatting and this was ok
Any thought on where I’ve gone wrong?
Thanks
I needed to perform a search and replace - one set of numbers, 600 plus, with another.
I opened a worksheet and typed abc in a cell then started the record a macro – next I used the find and replace option and replaced abc with xyz.
Next I stopped recoding.
I then stepped into the macro and cut and pasted the text to desired number of lines
Replacing abc and xyz with the desired set of numbers
I did a test with 20 lines of the macro and this was ok
I then went on and typed in the rest of the numbers 1200 of them!
Result was some were ok but many generated random numbers some with plus signs.
I checked the macro figures and all were ok
I checked the cell formatting and this was ok
Any thought on where I’ve gone wrong?
Thanks