Is it possible to change multiple cell values at once?

Hello,

I was wondering if it's possible to change multiple cell values at once without using a loop?

i.e. if I had a range of numbers in column 'A' and wanted to pick out the cells with value 57 and change those values to 75, could that be done.

Somthing like:

Please Login or Register  to view this content.

I know that doesn't work, but something along those lines?

Thanks

Alex